Problem resolved.  Had an issue with 2003 file securities I managed to work out.

Thanks John, here's the output.

Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)   May  3 2005 23:18:38   Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service...

Anyone have any thoughts?  Btw, the server ended up being a Quad 3.2 Xeon.

Thanks! 

Thank you!  That discrepency in the BOL was what I got caught up on before so it got me thinking that I could not rename an instance of SQL.

I appreciate...

Thanks for the tip.  Are there any recommendations for this type of technology (company or software)?

Not having a test environment to try this, will SQL 7.0 client talk with 2000...

Thanks for the help!  I have 7.0 and had to use a SP in order to do this.  It's working and now just trying to integrate the results from a...

Thanks Noel.  That makes perfect sense and should work.  I appreciate the help!

Thank you for the responses, I will do some follow-up.  We ended up rebooting the server which solved it this time.  It was odd since it was a record breaker...

Thank you for the info!  I did find this code in multiple places, but no instructions or direction with what to do with it.  I'll keep digging, but I appreciate...

Thanks to both of you!  We got this resolved.

Thank you!  Generally speaking, does the Regional Setting for Short Date ever matter on either the SQL server or client machines?  I have had a few instances where changing the...

Thank you for the advice.  I'll look at the formats and take a look.  The odd thing is the inconsistencies when it sometimes will work and sometimes it will not.

I...

I did just realized the limitation.  I created an online tool for marketing to create dyanmic lists to compare certain numbers from our database.  It worked great until the numbers...

I realized what was going wrong and it is now working fine. Thanks for the help!

Upon running the query, the following results are generated:

DTSRun: Loading...

Error: -2147008507 (80074005); Provider Error: 0 (0)

Error string: Unspecified error

...