This post is to share encounters with the “Index was out of range” error message while working in SQL Server Management Studio (SSMS), and to hopefully help you quickly resolve it error. If you get this error, your first troubleshooting […]
How to Export Data Using SSMS
This post contains a guide on how to export data from SQL Server to your local desktop using SQL Server Management Studio (SSMS). The default export option in SSMS is Column-Aligned, and we need to change it to Comma-Delimited to […]
How to Open SSMS with a Different Domain User
If you’re working with SQL Server in a corporate environment, you may need to connect to the server using a different Domain User account. For example, you may need to test the access and permissions of newly created SQL Server […]
How to Set the Default Database for SQL Server Users
When you log into SQL Server using SQL Server Management Studio (SSMS) and open a new query window, you will automatically be set to use your logins default database which was set during the creation of your SQL User. This […]
Importing Flat Files into SQL Server with SSMS
SQL Server Management Studio (SSMS) offers a feature called Import Flat File, which is a streamlined version of the Import Data feature. It minimizes the need for user intervention during a file import. This feature does not include the option […]
How to Filter Objects in SSMS
This guide simplifies the process of filtering objects in SQL Server Management Studio (SSMS), a handy feature often used by MS SQL DBAs to quickly locate tables, SQL logins, stored procedures, or any other objects in abundance. Finding a SQL […]