Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    91

    Unanswered: Get default database from user login

    Hi everyone -

    Is there a what to get the default database from SQL from a query line?

    Each of the users are assigned a default database, so i need to get the default database via a query after the user is authenticated.

    thanks
    tony

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    select db_name()

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    or perhaps even sp_helpuser
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

Posting Permissions

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