?
Solved

execute as - equivalents in SQL 2000

Posted on 2010-09-09
4
Medium Priority
?
326 Views
Last Modified: 2012-05-10
is there any provision like "execute as" in the older version?

what would be a possible alternative?

thanks
0
Comment
Question by:anushahanna
  • 2
  • 2
4 Comments
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 2000 total points
ID: 33639026
Hello,

execute as was added in SQL 2005, sql 2000 is so limited !

http://msdn.microsoft.com/en-us/library/ms188354.aspx

Hope that helps.
Thanks
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33639270
any alternatives possible in SQL 2000?
0
 
LVL 21

Assisted Solution

by:Jason Yousef, MS
Jason Yousef, MS earned 2000 total points
ID: 33639349
I don't think so, and can't find anything online

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/7db63373-8676-4a92-ac63-6575cbea4c94

but I think you can use  OPENQUERY as a loopback to itself  

SELECT * FROM OPENQUERY (ServerName, 'EXEC db.dbo.SPExample')
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33639431
Thank you.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question