Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesHello, Does anyone know what procedure to run to show information such as the owner of a specific database for MSSQL2000? I want to make a script to loop through all the databases on a server and display owner and other helpful information. Best regards, Andreas
Post Follow-up to this messageAndreas, I think the following query will work for what you want: Use MASTER SELECT name, SUSER_SNAME(sid) FROM sysdatabases HTH -- Mark D Powell --
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread