How to give owner rights to Database in sql server 2005

  • 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.

  • The owner of a DB automatically has access to it. Are you asking how to make a Login the owner of a DB?

    FYI: The full-text indexing is a separate question that should have its own thread in a different forum.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply