The solution for this seems to like the following:

DECLARE

@DBName VARCHAR(100),

@sql NVARCHAR(4000),

SELECT @sql...

I am trying to execute the following code but it does not seem to be setting context to the database using the execute (@SQL). It seems to stay in...

I was actually using a while loop but am not able to dynamically set the USE clause. How are you doing that. I need to set context to...

Michael, that works perfect!

Easy solution. Thank you very much.

-David

It says 0 rows copied whth an EOF comminication error.

-David

This is perfect. It works! Thank you very much.

You can not use a "USE " statement within a stored procedure. I am not sure what you are suggesting here. Could you please clarify?

Thank you

-David

Gail, thank you for the reply. This has led me to the following link which explains this issue:

https://www.labkey.org/issues/home/Developer/issues/details.view?issueId=2690

-David

Excellent! Thank you guys!!!

-David

>>UPDATE STATISTICS tableName WITH FULL SCAN;

FULL SCAN should be one word like:

UPDATE STATISTICS tableName WITH FULLSCAN;

I was using the wrong disk. Thank you.

David

Thank you all. This helps a great deal. Being that we do not have extra servers, I plan to do a side by side migration.

David

Okay, if I understand correctly, by upgrading my 7.0 database to 2005 it would have as compatibility level of 70, correct. At what point if any should I set...

Jeff, that fixed it. I thank you and all who responded for your patients and expertise in helping me solve this issue. Have a great day!

🙂

David

Thank you Jeff, I will pursue this and let you know how it turns out.

David