Yes, the Select runs fine but the BCP doesn't. I'm running the BCP in Query Analyzer in SSMS on the server and database the Select is run on. So I...

Thanks Chris,

That did the trick. I had to tweak it just a little to suite my exact situation, but I couldn't have done it without your help.

Thanks

BP

Thanks for your quick replies. I tried both. Phil's gave me the results I was looking for, but but Peter's did not. Not sure why.

Thanks again!

I have tried this script on several different servers and computers and keep receiving the following error:

Line: 86

Char: 1

Error: Unknown Runtime Error

Code: 800A03EC

Line 86 executes the following:

oExcel.Range(strNewCell).Activate

I...

"I wish my management had that goal."

Ditto

No rush Jeff. Whenever you get the time that would be great.

-BP

Jeff - you mention producing a deadlock report. Excuse my ignorance, but how would one go about producing such a report?

Thnx,

BP

Jeff,

You're correct. I wasn't dissapointed. This works even better that I could've imagined. I thank you for your time and effort.

Thanks again!

Brian

Awesome Jeff! Enjoying the weekend off and will get to it on Monday. I will post my results.

Thanks Again!

Brian