• sp_helplogins 'your loginame' would give you the default database name along with other info ...... If you are just looking for login name and default database .... you could run this

    select [name],dbname from sys.syslogins

    -------------------------------------------------
    -Amit
    Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]