Results 1 to 5 of 5

Thread: sql2k service not starting

  1. #1
    Join Date
    Aug 2003
    Posts
    3

    sql2k service not starting

    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

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    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

  3. #3
    Join Date
    Aug 2003
    Posts
    3
    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 ?

  4. #4
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    if u havent created any new database, it easy to reinstall.

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You run sql scripts in query analyzer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •