Geek asks and answers

Can I use the SQL 2005 profiler to profile the 2008 database

I am trying to track a SQL Server 2008 database, but I only have SQL Profiler 2005. (Don’t ask why, it doesn’t make sense to me either). When I try to start a new trace, I get "Cannot find the trace definition file for Microsoft SQL Server version 10.0.0. Click OK to get it from the server. The search may take several minutes."

I click Ok, then ... nothing.

Is there any way to make this work?

+3
source share
2 answers

SQL Server 2008 SQL Server 2005. "Microsoft SQL Server TraceDefinition 10.0.0.xml" ( "Microsoft SQL Server TraceDefinition 10.50.0.xml" ) "C:\Programme\Microsoft SQL Server\100\Tools\Profiler\TraceDefinitions" "C:\\Microsoft SQL Server\90\Tools\Profiler\TraceDefinitions".

, "C:\Program\Microsoft SQL Server\90\Tools\Profiler\Templates". SQL Server 2008 "100", SQL Server 2008R2 "1050". Profiler SQL Server 2008, SQL Server 2005 "C:\Programme\Microsoft SQL Server\90\Tools\Profiler\Templates\90" - SQL Server 2008 .

+6

, , SQL2008, , SQL2005, :

C:\Program Files\Microsoft SQL Server\90\Tools\Profiler\TraceDefinitions

SQL2008 ( XML), , , !

0

More articles:


All Articles