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.
               (
geocities.com/upkusurkar)