Important System Stored Procedures

1. exec sp_helpdb [ [ @dbname= ] 'name' ]
Get database information like Database name, Database Size,Owner etc.

2. master..xp_getnetname
Returns the network name of the SQL Server.

3. exec sp_renamedb
Changes the name of a database.

4. exec sp_changedbowner
Changes the owner of the current database.

5. exec sp_helplogins
Provides information about logins and the associated users in each database. 


    Source: geocities.com/upkusurkar/DatabaseScripts

               ( geocities.com/upkusurkar)