Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/6

Click to flip

6 Cards in this Set

  • Front
  • Back
What is the GPS_SQL_Error_Codes Table?
Lists descriptions for each error message code. Use Query Analyzer or Enterprise Manager.
What is SQL Server Profiler?
It monitors the performance of stored procedures, determines if a workstation has stopped processing and view database tables being accessed. Tools > SQL Profiler
What are the 3 entries for the dex.ini file to create the dexsql.log?
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
What does dexsql.log do?
The dexsql.log file records any executed SQL statements and ODBC calls. The Profiler only records SQL Statements.
What is the difference between dexsql.log and SQL Server Profiler?
The dexsql.log records only one workstation. The Profiler records the activity for a user or the server.
What is the operational difference between dexsql.log and SQL Server Profiler?
The dexsql.log is for troubleshooting errors. The profiler is to monitor processes.