Since the database files are already on the disks being moved, all you need to do is to attach the database to the newly installed server. All server logins need...

Are you replacing server A or making a standby server?

What happened here is that the database user is out of sync with the server login, which gives the error '... not a valid user...'.

'sp_change_users_login' should fix this broken link.

Has anybody tried this 'sp_change_users_login' on a 6.5 database? I couldn't get it to fix the login, but ended up deleting and recreating the login, which removed all the database...

I got the same error msg. Click the link provided, you should be able to answer from there.

http://www.sqlservercentral.com/testcenter/QOD.asp

Thanks again for your help, Everett.

I got it to work.

WM

One last question, Everett:

How do I create a dump device for each database in the script?

Thank you.

WM

It ran successfully! 🙂

Thank you very much, Everett, for all your assistance.

WM

The printed statements are correct and can be run successfully manually. But I got the error when it is executed with the EXEC @CreateDatabse command.

WM

Thanks again, Everett.

I got the MaxSize worked out and printed out the Create Database statements. However, when I tried to run the code with the

EXEC @CreateDatabase statement, I got...

Hi Everett,

Thanks for your reply.

Where should I put this line? It does not seem to work:

CONVERT(char(2),@DataSize) and CONVERT(char(2),@LogSize).

Also, for the MaxSize, can I do something like set @MaxSize...

Hi,

I am still working on the script supplied by Everett. I am getting the following error when putting the int value into the create database statement. Any suggestions to make...

Thank you, mworku. I will modify and run it today. I will post the result.

WM

Thank you very much, Everett. I will try that and let you know how it goes.

Thanks again for your help!

WM

Please Heeeeeeeeeeeeeelp.

THANK YOU!

WM