Default database

Last Post 11 Mar 2010 06:13 AM by rm. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sql-tips
New Member
New Member

--
10 Mar 2010 01:22 PM
I create a user and assign a default database. It works fine for sometime. suddenly started giving user default database is not assigned. when I check login, default database is master, assign db_owner role to my regular database. Usually when this error occurs?
rm
New Member
New Member

--
11 Mar 2010 06:13 AM
You'll see that if default db is restored or so. When you check login properties, it may display next db as default db. In sql2k, you'll see blank default db in login list.
You are not authorized to post a reply.

Acceptable Use Policy