Category

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

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()]