Kamis, 17 Februari 2011

Changing a SQL Server Database Owner

Fact: every SQL Server database has an "owner". You can check the owner of a database by running this query:SELECT NAME, SUSER_SNAME(owner_sid)FROM   sys.databasesWHERE NAME = 'DatabaseName' However, there may come a day when you run into this error:There was error outputting database level information for ServerName.DatabaseName.Property Owner is not available for Database '[DatabaseName]'. This

Tidak ada komentar:

Posting Komentar