on 04-18-2007 6:37 AM
Hi,
We are trying to trace / track the error log record on SQL server database, Where I am able to find the record Id but not the error log records & the relavent information
If anybody knows please answer the query.
Thanks with regards,
Sunil
Hi Sunil
Which error log are you referring to?
The SQL Server error log is in the SQL Server's "LOG" directory, and is called "errorlog". open it with notepad. The logs are rotated ("errorlog" is current, "errorlog.1" is prior to current, "errorlog.2" is prior to prior to current ,etc.) If the log isn't there, then look at the startup parameters of the SQL Server (-e value, IIRC.)
HTH
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunil
Start "Profiler" from your "Microsoft SQL Server" programs group.
File -> New -> Trace. Enter SQL Server connectivity info.
Select "Filters" tab from next window, configure (at the very least) the databasename and loginname of the MDM underlying repository database.
Don't start the trace just yet - MDM frequently does a LOT of stuff on the database. Try to minimise what the trace returns by starting it just before you effect (and save) a change to the workflow, and then stop the trace immediately.
The Profiler will provide you with ALL the SQL statements executed according to the filter criteria for the duration that the trace was running. It's then just a (time consuming) matter of stepping through the SQL statements and procedures to see exactly what was done to the database.
Mark
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.