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

SUMMARY

This document details the step-by-step instructions on how to change the default database on a SQL Server login.

  • Grant the user with right to the database you want to set as the default database
  • Connect to the database using SQL Server Management Studio with the login you wish to change
  • Click New Query Button
  • Execute the following command
    • Alter login with default_database =
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Can I have more logins for my MS SQL database?

DETAILS Yes.  In addition to the default login assigned for each SQL database addon, you...

Transferring SQL 2005 databases

SUMMARYThis document provides a step-by-step guide on how to transfer your current SQL Server...

How do I assign additional SQL logins to my SQL 2005 database?

SUMMARYThis document details the step-by-step instructions on how to assign a SQL login...

Can I have more than 1 MS SQL database with my hosting account?

DETAILS Yes.  You can order up to 5 MS SQL 2000 database addons per account. 

How can backup/export my database

You can export your database by going to http://sqladmin.oissite.net/. You need to login using...