Inoffizielles deutsches Xbase-Forum

Code: Alles auswählen

Create Table SqlLogging(
  "ID" Autoinc            /* unique key for the query */,
  "Start Time" Timestamp  /* Query start timestamp */,
  "Optimized" Logical     /* True if optimized */,
  "Return Code" Integer   /* Query result code */,
  "Rows Affected" Integer /* Rows affected by the query */,
  "End Time" Timestamp    /* Query end timestamp */,
  "Run Time" Double       /* Query duration in milliseconds */,
  "Database" Char(255)    /* Database name */,
  "User Name" Char(100)   /* Connected user name */,
  "Connection Name" Char(100) /* Connection name */,
  "Application ID" Memo       /* Application ID */,
  "Query" Memo                /* The SQL statements */
)

Code: Alles auswählen

execute procedure sp_EnableQueryLogging( 
  'SqlLogging'/*TableName*/,TRUE/*TruncateExistingData*/,
  FALSE/*LogOnlyUnoptimizedQueries*/,0/*MinimumTimeBeforeLogging*/,
  ''/*EncryptionPassword,C20*/ )

Code: Alles auswählen

select SL."Start Time",SL."Run Time",Left(SL.Query,50) Query50,SL.Query,SL.Description
from   SqlLogging SL

Code: Alles auswählen

execute procedure sp_DisableQueryLogging();