SQL Server 2005 Workgroup Edition (1 Viewer)

[AnnPhil]

Has anyone used SQL Server 2005 Workgroup Edition?
I have an SQL Server 2000 database that i need to move to a new server that has the 2005 Workgroup Edition. What is the easiest way to do this? All that need to move are the tables which are on the 2000 SQL server. The queries, forms and reports are on a front end of Access 2003.

 

[pdx_man]

I do not have this, but you should be able to backup and restore the databases. Be sure to have all of your logins on the server prior to the restore. You may still have to re-link the users and the databases, though. This is done through:

EXEC sp_change_users_login 'auto_fix', 'YourUser'

Get a report of the orphaned users by running this on each DB:

EXEC sp_change_users_login 'report'