Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  2000 emulation of 2005 Execute As User

Author  Topic  Bazori Starting Member 1 Post Posted - 2006-07-20 : 13:39:19 Hi, We have used a lot of Execute (String) in our procs. The problem is to use this type of function in 2000 we had to allow update and delete permissions for our Windows Auth users or else these executes would not run. We are looking for something similar to 2005's Execute As User functionality we can add to our procs to change the login/user without having to go rewrite all of our applications. Any advice. Thanks, Bazori