I have a proc that collect disk space usage from the server. When I execute that proc it works fine. When I insert the results into a table it fails with the error: An INSERT EXEC statement cannot be nested. The command: insert into dba_diskspaces (server,Drive,Free_MB,Total_MB,Free_Per) exec dba_diskspace...

I have a SP that I can run from QA, and command line with no issue. But for some reason it hangs when it's called from the APP. At first we thought it was a cache issue so I put WITH RECOMPILE in the SP. so we started a trace in it. We found the part that was having the issue. The issue is at a Link...

Both Servers SQL 2005 sp2 Ok, this has stumped me. I was running a stored procedure and found it was very slow and drilled down to a statement that updated most columns on a table on a linked server. So I separated the statement out into 1 separate update per column. Some ran instantly, 4 of them 17...