You're the man, thanks! I'll create the new script using your suggestion above and let you know how it goes. THANK YOU!

Thanks, Jacek. I'll ive the temp table a shot.

JacekO (4/17/2009)

---

How many rows are we talking about? And how often do you need to run it?

Can you link the 2000 servers to the 2005 server?

Also the five columns you...

LOL that is the same thing I told the guy who I wrote the script for when he told me about the error. 😛 Where I...

Hi Guys,

I've hit a bit of a snafu with this one. The script will need to be executed against 2000 servers as well, so the ROW_NUMBER() function will...

Jacek, I will try your next for sure! Here is the code with Slanges suggestion. This script is for a developer here in my office, so i just made the...

Thanks, Guys! I went with slange's suggestion first and it works great. THANK YOU!!!!

Thanks for your help, Steve. This report would be run every week against a UAT instance of one of our production databases, so efficiency is not critical

Hi Steve,

I'm executing the script manually and saving results to file (.xls)

I really wanted to modify the script so I could avoid any manual work on the excel...

The formatting I put in the post got messed up, so I hope it makes sense what I'm trying to do.

I have job running the packages that deliver to Excel. I seem to be making some sort of progress now. I deleted the file from the share, and then fired...

Thanks for the reply. yes, it is going to the same directory as my XLS files. With that said, could it still be a permission issue?