Simplified steps for creating BID / ETW traces for ADO.Net and SQLNCLI

In order to create BID traces for ADO.Net and/or SQLNCLI/10 follow these simplified steps:   #1 On the machine where client code runs, create a new directory called C:\BID #2 Locate the appropriate diagnostic dll.   ADO.Net: For .Net 2.0, default location is: C:\Windows\Microsoft.NET\Framework\v2.0.50727\AdoNetDiag.dll For .Net 4.0, default location is: C:\Windows\Microsoft.NET\Framework\v4.0.30319\AdoNetDiag.dll   SQLNCLI an SQLNCLI10…

0

Invalid object name ‘MSysConf’. (State 42S02) (Code 208)

Sometimes customers call in wondering why they have the following Exception and User Error Message in their SQL Profiler log:   Exception: Error: 208, Severity: 16, State: 1 User Error Message: Invalid object name ‘MSysConf’.   or, if they replay a SQL profiler trace, it may be a Replay Provider Error:   [Microsoft][SQL Server Native…

0