sql server msde: I would like to know how I can move current MSDE 2000
database to SQL 2000 database. I want to put all
databases on my 1 SQL server.

The simplist way to do this is to backup and restore the databases to your
new server. You will then need to add any SQL Server logins to your new
server that are users in your databases. Then run sp_change_users_login (see
BOL) to synch the database users with the logins.

Jim

[quoted text, click to view]