Category

December 15, 2015

In category: DataBase, MySQL | Posted by Sanj

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

In category: DataBase, SQL | Posted by Sanj

you can prevent store procedure infinite loops by wrapping the code between BEGIN and END i.e [crayon-5a359b86c25e9175134971/]      

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

In category: Project, SQL | Posted by sanman

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