I am trying to run the Tuning profile in SQL Server Profiler 2008 against an
SQL Server 2000 database, but I get the following error message when I try to
start the trace:

---------------------------
SQL Server Profiler
---------------------------
Failed to start a trace.
[Microsoft][SQL Server Native Client 10.0]Datetime field overflow.
Fractional second precision exceeds the scale specified in the parameter
binding. (State 22008) (Code 0)

---------------------------
OK
---------------------------


Any ideas at all?

Thanks
Tom

tomf84 (tomf84 (AT) discussions (DOT) microsoft.com) writes:
It works for me. Did you add any filter to the trace?

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

"Erland Sommarskog" wrote:

This is repeatable for me. Standard trace template (or any template).
don't touch a thing EXCEPT for selecting "Enable Trace Stop Time". This is
the culprit.

Only throws error when running against 2000. 2K5 and 2K8, no error.

sorry, forgot to include profiler version info (copy info on help about was
the greatest invention since rollback!)

SQL Server Profiler 10.0.1600.22
Microsoft Data Access Components (MDAC) 2000.085.1132.00
(xpsp.080413-0852)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.5512
Microsoft .NET Framework 2.0.50727.3082
Operating System 5.1.2600

"dwaine" wrote:

dwaine (dwaine (AT) nospam (DOT) nospam) writes:
I see. Yes, that's definitely. There has been some changes with the
datetime data types in SQL 2008. That probably has something to do with it.

I tested this in SQL 2008 SP1 as well, but the issue persits.

I've filed a bug for this:
https://connect.microsoft.com/SQLSer...dbackID=435233


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx