RSSArchive for May, 2013

May

1

Change the Default Database for a User in SQL Server

Posted by Leave a Comment

Here are three easy ways to change the default database for a user in SQL Server.

Option 1: Execute the system stored procedure sp_defaultdb

EXEC sp_defaultdb @loginame='UserName', @defdb='NewDefaultDB'

Continue Reading