How to give owner rights to Database in sql server 2005

• saranram_forum

  SSC-Addicted

  Points: 410

  More actions

  May 11, 2009 at 6:57 am

  #204132

  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.

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  May 11, 2009 at 7:27 am

  #992097

  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]