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 2005 Forums
 SQL Server Administration (2005)
 xp_execresultset

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-04-02 : 19:34:12
SQL2K had master.dbo.xp_execresultset, has this been removed from SQL2K5?

------------------------
I think, therefore I am - Rene Descartes

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-02 : 22:21:52
Yes. see http://sqlblog.com/blogs/adam_machanic/archive/2006/10/19/replacing-xp-execresultset-in-sql-server-2005.aspx


KH

Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-04-02 : 23:27:05
Thank you Khtan. Luckily the guy in the article has given his own version of xp_execresultset. Did anyone check this?

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-02 : 23:32:04
You can always try it out yourself.


KH

Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-04-03 : 19:11:54
I will do that. Thanks

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page
   

- Advertisement -