NOTE: We strongly recommend migrating from SQL 2000 to SQL 2005 or 2008. As Microsoft continues to move forward with SQL server technology, SQL 2000 will fall further behind the standard. It is no longer actively developed or updated, as it has been superseded by SQL 2005 and 2008. While we will continue to maintain our existing SQL 2000 servers, our recommendation is to upgrade your SQL service to a more recent version at your earliest possible convenience.
If you decide to migrate your SQL database we have a forum post on the steps needed to complete this process.
How to change the default database on a SQL Server login:
- Grant the user with rights to the database you desire to set as the default database (see this Knowledge Base article)
- Connect to the database using Enterprise Manager with that user (see this Knowledge Base article)
- Expand the Security node
- Click Logins - this should bring up a list of users on the right pane
- Double click on the user, for which you want to change the default database setting. This will bring up the login property dialog box
- In the Defaults - Database section, you should see a list of databases that the user has rights to. You can select the default database in the dropdown box
- Click OK
Article ID: 217, Created On: 11/14/2008, Modified: 1/10/2012