se Master
Go
Sp_DbOption , 'Single User', True
Go
Exec Sp_ReNameDb '', ''
Go
Sp_DbOption , 'Single User', False
Go
Note: You must restart or refresh the Query Analyzer to view the name change...
more »
Use DataBaseName
Exec Sp_HelProtect @grantorname = 'Dbo'...
more »
SELECT USER as [User],
SESSION_USER as [Session_User],
CURRENT_USER as [Current_User],
SYSTEM_USER as [System_User],
ORIGINAL_LOGIN() as [Original_Login()]
...
more »