Replacing xp_execresultset in SQL Server 2005

(Adam Machanic) SQL Server 2000 included a very useful extended stored procedure called xp_execresultset. This XP had two parameters: @cmd and @dbname. @cmd was expected to be a SELECT statement that would produce a single column of output, each row of which would produce a valid query. @dbname was

Read More - Register for Free Membership