How to upgrade msde 7.0.623 to MSDE 2000

[pctekkk]

sorry for the newbee ?
but i'm trying to upgrade msde 7.0.623 to msde 2000 for an application via
sql2ksp3
but wont work
any assistance please ??

thanks

 

[WhiteKnight57t]

Define not working?

is there an error message

==========================
Sorry to be terse
some say it's a curse
I know it's worse
I'm just diverse
-Tim

 

[pctekkk]

nevermind,
had removed 7.0, reg hack to delete all folders
related to v7.0
then reinstalled msde 2k


now i'm trying to figure out how to move the db's from the C:\ to
the
D:\
(basically relocate to diff drive same server)

thanks

 

[mrdenny]

move the files to the new location, then use sp_attach_db to get the databases attached to the SQL Server. If the databases are already attached you'll need to run sp_detach_db to detach them from SQL. Check BOL for more info.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)