• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

execute as - equivalents in SQL 2000

is there any provision like "execute as" in the older version?

what would be a possible alternative?

thanks
0
anushahanna
Asked:
anushahanna
  • 2
  • 2
2 Solutions
 
Jason Yousef, MSSr. BI  DeveloperCommented:
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
 
anushahannaAuthor Commented:
any alternatives possible in SQL 2000?
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
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
 
anushahannaAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now