Category
March 6, 2014
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 <...
October 2, 2008
In category: SQL | Posted by sanman
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...
October 2, 2008
In category: SQL | Posted by sanman
Use DataBaseName Exec Sp_HelProtect @grantorname = ‘Dbo’
October 2, 2008
SELECT USER as [User], SESSION_USER as [Session_User], CURRENT_USER as [Current_User], SYSTEM_USER as [System_User], ORIGINAL_LOGIN() as [Original_Login()]