Category
December 15, 2015
I was migrating a wordpress site to a new server, and had some issues using with the migration plugins, so went back to manual process and uploaded all files via...
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()]