November 14, 2008 at 10:33 am
Not sure if there is a better way, but you can create a linked server pointing back to the original server (like a loopback). Then you can use the OPENQUERY command in the view.
Something like..
select *
from openquery(loopback, 'exec msdb.dbo.sp_who')
November 14, 2008 at 10:45 am
AShehzad (11/13/2008)
Is it possible to create a view that will be populated by record set generated by execution of a system stored procedure?
no, not using a system stored procedure.
also with sql2005, keep in mind, you may be able to select from a system dmv, but by default, you'll only get the info you're actually entitled to.
With SQL2000 if you select from e.g. sysprocesses, you got to see all info in sysprocesses. With the sql2005 equivalent, you'll only get to see your own spid info.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 31, 2011 at 4:24 am
I am also having the same problem. i want to create a view using a stored procedure i created. Pliz help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply