Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Location
    India
    Posts
    38

    Unanswered: Query Analyzer - Urgent

    Hi
    I installed the Sqlserver-2000 in my Server. But When I am trying to Open a Query Analyzer It is Showing the Default database is master.

    But I want to Change into my Database.

    Can anyone Help me..

    thanks
    -- Prasad --

  2. #2
    Join Date
    Jun 2002
    Location
    Belgrade
    Posts
    10
    When registering User , you have option to set the default Database.
    Then you set your Database as default.

    Expand Server >> Security >> Logins >> UserName(right click) Properties >> look down >>>>>>....."Specify the default language and Database for this Login."


    rgds.
    srdjan

  3. #3
    Join Date
    May 2002
    Posts
    25
    you can also use the stored procedure

    sp_defaultdb [ @loginame = ] 'login' ,
    [ @defdb = ] 'database'

  4. #4
    Join Date
    Feb 2002
    Location
    India
    Posts
    38
    Thanks a Lot.

    It is workring fine

    Thanks
    -- Prasad --

Posting Permissions

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