I've scripted a sql trace for Sql Server 2000 and added the filename in the appropreate location andthe result is a column called ErrorCode with a value of 14. Can anyone tell me what this error code means and what could be infered about what I need to resolve it?
Thanks,
Marc
It is most probably the call to sp_trace_create that fails. You can inspect the script to find out which one of the system stored procedure call is failing. For example, error code 14 indicates the stop time is incorrect for sp_trace_create. See BOL topic below:
http://msdn2.microsoft.com/en-us/library/ms190362.aspx
Also, if you double-click on the error message in SSMS you should be positioned on the call that failed. This should give some idea as to which system SP call failed.
No comments:
Post a Comment