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
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar