Posted by Plamen Ratchev on 12/20/07 15:22

In SQL Server 2000 you could use the SETUSER command
(http://msdn2.microsoft.com/en-us/library/aa259240(SQL.80).aspx) to
impersonate the user context for a SQL user account. However, this can only
be used by a sysadmin or db_owner and could not be used for Windows
accounts. In SQL Server 2005 you can use the EXECUTE AS clause to change the
execution context.

Here is a good article about EXECUTE AS:
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/21/642061.aspx

HTH,

Plamen Ratchev
http://www.SQLStudio.com

[Back to original message]