Problem profiling SQL 2000 server from 2008 profiler



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
.



Relevant Pages

  • SQL Server Profiler
    ... I ran SQL Server Profiler. ... that there were a few times when someone tried logging in ... Is there a way to trace the IP address of these client ... machines who are trying to hack into SQL Server? ...
    (microsoft.public.sqlserver.security)
  • SQL Server Security
    ... I ran SQL Server Profiler. ... that there were a few times when someone tried logging in ... Is there a way to trace the IP address of these client ... machines who are trying to hack into SQL Server? ...
    (microsoft.public.security)
  • Re: fine tuned tracing for sql server job execution
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > I'm thinking of using sql server profiler and/or the windows performance> logs, to trace a problematic job which> fails to retrieve any rows by executing a dts (which inbcludes transfare> data tasks). ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server Security
    ... > I ran SQL Server Profiler. ... From the trace, I found out that there were ... > trying to hack into SQL Server? ... There has been a huge increase in scans on port 1433 to which SQL Server ...
    (microsoft.public.security)
  • Re: Profiler and transaction logs...
    ... off by the rather steep price tag - which, for what is likely to be a ... Profiler can't "replay transaction logs".. ... Is it possible to use SQL Server Profiler to replay a transaction log? ...
    (microsoft.public.sqlserver.tools)

Loading