I would like to know if it's possible to transfer a database from MSDE to SQL 2000 with the use of sp_detach_db from MSDE and sp_attach_db tp SQL2000Yep. Just handle orphaned users afterwards. sp_change_users_logins or
http://dbmaint.com/SyncSqlLogins.asp.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:C3EE7F95-750A-4559-AC34-3D1514DA5919@.microsoft.com...
> I would like to know if it's possible to transfer a database from MSDE to
SQL 2000 with the use of sp_detach_db from MSDE and sp_attach_db tp SQL2000
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment