Hi,
     I need to know that how to give the owner rights to database in SQL server 2005 and how can we secure the database and how to enable Full-Text Indexing in my database.By default, I am having option to enable Full-Text Indexing but this is disabled.

I, personally, wouldn't go near a SQL Server Database without my faithful  'SQL Server Administrator's pocket book' by Staneck. The answers to all these questions are in the pocket book.

Hi there.

Apart from Phil being right on the spot, the main idea is this: there are extremely few cases in which you need to grand administrator rights to a database. Best shot is to grant the necessary rights at the DB level to a particular SQL Server login to do "administrative" tasks; in this way, you only need a couple of GRANTs and you're good to go.

Please let me know exactly what you need and I might be able to help.

best regards,
io