Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
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.
|
