search

Google
 

Tuesday, February 5, 2008

How to change Default DataBase in SQL Server 2005

ALTER LOGIN [Login_Name] With default_database = [Database_Name]

Example:-

alter login sa with default_database = ourspace

No comments: