Michael,

Thanks for the information it worked like a charm.

The SQL ServerCentral site has been very helpful to me for some time.

I wasn't sure if the problem I was having was...

==Thanks. I've not had an occasion to set the timeout so I used what I found elsewhere which really didn't explain the whole topic. The SP is taking...

Robert,

Excellent article. I have found many uses for the SQL Output but have one small problem.

Can anyone point me toward some example code that shows how to gather the...

Got it. Thanks a million. I'll give it a try and let you know.

Thanks to both of your for some valuable points in the right direction.

The incoming spreadsheet may or may not have rows with numberic values in the preceeding rows; however, I...

Michael,

Will do.  I'm glad to know that I am on the right track with this.

Thanks for your knowledeable and rapid help.

John

Michael,

Thanks.  I've tried to use the shell method.

Should I be executing this directly from the VB code or from and EXEC statement in a stored proc? Or does it matter?

Thanks,...

Webrunner,

I have had good success with just backing up a SQL2000 and then restoring it to SQL2005.  On all the DBs that I've migrated this process has worked for all...

I have also had the problem on a continuing bases and kept creating new logins everytime we migrated DBs to a new instance of SQL2005.

The process mentioned above worked when...