Category: SQL

  • Check for Objects in SQL Server

    Examples of how to check your SQL Server database for existing tables, stored procedures, indexes, etc. Use them before you drop/create/modify to avoid errors.

  • How to Run SQL Server Management Studio as a Different Windows User

    If you’re using Windows Authentication for your SQL Server database you’ll need to run SQL Server Management Studio (SSMS) as that Windows account to test queries.  SSMS normally runs as the user logged in to Windows, but there is a simple way to run it as the database access account. Just shift-right-click on a shortcut…

  • Quickly See a Table’s Columns in SSMS

    When looking at long queries you’ll typically need to remember what data is in one of the tables.  SSMS allows the creation of shortcut keys that can be used to quickly look at the first row in a table.  You’ll then be able to see the column names and some example data. In SQL Server…