SQL: My daily used SQL Syntaxes

Friday, August 19, 2011

1. To find the SQL

SELECT DISTINCT a.name

FROM SYSOBJECTS a inner join SYSCOMMENTS b

ON a.id=b.id WHERE b.text like '%Product%'

2. Change the User in SQL 2000

SETUSER 'Domain\User'

Example :

SETUSER 'MyDomain\Hitesh'

3. Change the User in SQL 2005/2008

EXECUTE AS LOGIN = 'Domain\User'

Example :

EXECUTE AS LOGIN ='MyDomain\Hitesh'