Same was happening with xp_cmdshell as well. But using no_output option did resolve the issue with xp_cmdshell.

Any help in this regard is much appreciated.

Thanks David. This information was useful.

/*

To my knowledge there is no System stored procedure to serve your purpose. However you can rely on sysdepends for dependant objects, if you have updated statistics.

This was a requirement...

Are you talking of the table that Server creates temporarily; while joining tables, filtering based on where clause and then returning the resultset.

In short are you talking of "The...

I am also planning to write 70-229 in last week of feb. These are the books I am currently looking at:

1. MCAD/MCSE/MCDBA Self-Paced Training Kit:

Microsoft SQL Server 2000 Database Design...

The above one works..

Replace the last line

exec master.dbo.xpcmdshell @cmd

with

exec master.dbo.xp_cmdshell @cmd

Cheers

Article is fantabulous. Remembering connection string was so hard. This udl trick has reduced me lot of time. Thank you Andy