Change Default Database in SQL Server Management Studio

imsatasia March 18, 2013 0 Comments

Change your login name and database name and Execute following SP: Exec sp_defaultdb @loginame='imsatasia\Rahul', @defdb='DBName' OR Go to "Object Explorer > Security > Logins" Right click your Login and click…