Category

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-59989db6ab2ad085365871/]      

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