Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0

How do I change the default database of a database login in SQL 2005?

Step-by-step instructions to change the default database on a SQL Server login:
  1. Grant the user with right to the database you want to set as the default database (see this Knowledge Base article)
  2. Connect to the database using SQL Server Management Studio using the login you wish to change
  3. Click New Query Button
  4. Execute the following command:
Alter login <loginname> with default_database = <name of default database>

Article ID: 194, Created On: 11/13/2008, Modified: 11/2/2010