Moved like a champ... Thanks

>>What is the best and fastest way to relocate a database? I’m using SQL7. The data is currently located in the default SQL directory. I need to move it to a larger local drive..
>
>1. sp_detach_db 'mydatabase'
>2. Move the database
>3. sp_attach_db 'mydatabase','myfilename'
>
>HTH.