Solved

execute as - equivalents in SQL 2000

Posted on 2010-09-09
4
315 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 500 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 500 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now