Re: changing db location on sql2000

Right click the datbase, all tasks, detach database. Move the files to D.
Right click "Databases", all tasks, attach database

Or you can do the same things with sp_detach_db and sp_attach_db if you are
happier in code

--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"cj" <cj@xxxxxxxxxxxxx> wrote in message
news:%23JESU1YbIHA.5160@xxxxxxxxxxxxxxxxxxxxxxx
I've got sql server 2000 desktop running on a windows xp pro machine. My
C: driver is too small and I'd like to move the databases to d: now. How
do I change the location of the databases?


.

Loading