RSSCategory: SSMS



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



Change SELECT TOP Value in SSMS

Posted by Leave a Comment

If you want to change the value of the default ‘SELECT TOP 1000’ option when you right-click on a table in SQL Server Management Studio you can do so by going to the Tools -> Options menu:

Continue Reading