Track-It!: How to run a SQL Query across Track-It! Database?

Knowledge Article

Track-It!: How to run a SQL Query across Track-It! Database?
How to run a SQL Query against the Track-It! Database using SQL Server Management Studio (SSMS)?
Track-It!
Track-It!
Track-It! 20xx & Track-It! 11.4 sp1 versions
Track-It!
Track-It!
Track-It! 20xx & Track-It! 11.4 sp1 versions
How to run a SQL Query against the Track-It! Database using SQL Server Management Studio (SSMS)?
  1. Log into SQL Server Management Studio (SSMS) with a SysAdmin (SA) or equivalent account.
  2. From the “Object Explorer” on the top-left, expand the Server name, then expand Databases.
  3. Right-click on the Track-It! Database and select "New Query".
  4. Type the query in the blank window in the middle of the screen with the blinking cursor, or paste the query contents in here after copying it from like a .sql or .txt file.
  5. Press F5 on your keyboard to Execute the query or select "Query" from the Menu bar in SSMS and use the "Execute" option.
Track-It!
Track-It!
Track-It! 20xx & Track-It! 11.4 sp1 versions
Attachment(s):