Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is it able to trace remote SQL Server 2008 using SQL Profiler 2005? If yes, anyone knows what else should I do, if during loging in appeares this message "Unable to locate trace definition file for microsoft sql version 10.0.0"?

I tried to go on by this link (http://blogs.msdn.com/b/sqlserverfaq/archive/2011/01/14/unable-to-read-trace-definition-file-microsoft-sql-server-tracedefinition-n-n1-n2-xml.aspx), but my SQLPath looks good. Any suggestions?

share|improve this question
    
Upgrade your tools to at least 2008 R2. There's no reason to be running the old versions. –  Jon Seigel Mar 12 '13 at 17:22
add comment

2 Answers

up vote 1 down vote accepted

Those messages about 'unable to read trace definition' and the fix are always from a newer SQL Profiler version trying to connect to an older SQL Server version. You are trying the other way (from older SQL Profiler to newer SQL Server) and it won't work. AFAIK You need to use SQL Profiler 2008 or newer.

share|improve this answer
add comment

Instead of using the profiler, try to run a server-side trace.

You can start here: http://www.toadworld.com/platforms/sql-server/w/wiki/10400.the-server-side-trace-what-why-and-how.aspx

Or you can just use the profiler to script out the trace creation.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.