was able to reformat above code a bit and run successfully, thanks...

thank you for the helpful script; the original version ran fine when I tried on SQL2000, but above fixed script results in error, anyone else have this issue? Thanks...

Msg...

Just wanted to follow-up to above: Currently suspecting network latency, as SQL test and Oracle prod servers are located in West Coast data center, whereas SQL prod server is located...

I will check on the network route between Oracle server and SQL Server prod vs. test next week when I'm back at the office, as I questioned that too...thanks for...

there's additional logic throughout sp, for example @openrowset is assigned to point to prod vs. test Oracle server depending on whether sp runs on SQL Server prod server vs. test...

thanks again...

any other easy/proven way to query the last updated date for stats across all databases/tables/indexes? ideas are welcome, as I'm guessing I'll be writing a custom script to...

thanks for your reply...I'm assuming that applies to STATS_DATE as well?

rg

somewhat related topic. I'm trying to use INDEXPROPERTY, STATS_DATE and other functions in command string for sp_msforeachdb. When I run query against single user database the values...

What version of SQL Server 2005 are you running? 64-bit?

Legacy DTS packages can be run using the DTSRun.exe, but in 32-Bit SQL Server 2005 only. See below links for...