Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2005
    Posts
    73

    Unanswered: Identifying the database path in 2005

    Hi-

    I have installed a SQL 2005 software and created 4 instances and 4 databases on each server namely , Adventureworks , sample , testdb1, testdb2.

    After creating these many databases , i was very confused to find out the actual database files in Programfiles directory as each instance was created in a separate directory namely MSSQL.1 , MSSQL.2...etc.

    how do i identify the correct database path for sample database in instance3.

    is there any system tables or stored proc that i can user to identify this path.
    tanks

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Have a look at either sys.database_files, or sys.master_files.

  3. #3
    Join Date
    Mar 2005
    Posts
    73
    Thank you Mcrowley.

    I have got one more question . How do remove already dropped
    instances from the connect window.

    Whenever i try to connect to a instance , i see a plenty of dropped instnace entries. How could i clean that stuff.

    thanks

  4. #4
    Join Date
    Aug 2005
    Posts
    75
    dunno if there's a way to delete from the UI, but in the registry:

    HKLM\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\ LastConnect

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You can use this statement:

    Code:
    exec master.dbo.xp_regdeletevalue
                N'HKEY_LOCAL_MACHINE'
               ,N'SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\LastConnect'
               ,N'OldServer1'
    Just replace OldServer1 with the server name of your choice.
    Last edited by rdjabarov; 05-11-08 at 19:05.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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