hi,
i have installed sql2k program to c: drive and database to f: drive. however, after changing the drive letter from f: to g: i am not able to start sql server service anymore. It seems like sql2k is looking for f: drive.
pls help.
thanks
Printable View
hi,
i have installed sql2k program to c: drive and database to f: drive. however, after changing the drive letter from f: to g: i am not able to start sql server service anymore. It seems like sql2k is looking for f: drive.
pls help.
thanks
change the drive letter back to the way it was. Follow the article to move the database to new location.
http://support.microsoft.com/default...NoWebContent=1
i am new to sql2k, can i know where to type this:
use master
go
sp_detach_db 'mydb'
go
or can i re-install the sql2k ?
if u havent created any new database, it easy to reinstall.
You run sql scripts in query analyzer.