Category

you can prevent store procedure infinite loops by wrapping the code between BEGIN and END i.e CREATE PROCEDURE LoopCheck AS DECLARE @i int SET @i = 0 WHILE @i <...

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...

Use DataBaseName Exec Sp_HelProtect @grantorname = ‘Dbo’

SELECT USER as [User], SESSION_USER as [Session_User], CURRENT_USER as [Current_User], SYSTEM_USER as [System_User], ORIGINAL_LOGIN() as [Original_Login()]