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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a vs2005 application that uses SQL Server 2005. I was trying to collect the SQL trace generated by the application while executing. For collecting the trace I've connected to SQL Server 2005 through SQL Server 2008 R2 Profiler. To my disappointment I found no trace data were collected by the SQL Server 2008 R2 Profiler.

I'm using Win 7 64-bit

Am I missing anything ? Can anyone advise on this ?

share|improve this question

migrated from Jan 4 '13 at 9:34

This question came from our site for professional and enthusiast programmers.

You're going to need to tell us exactly what you did. Are you sure you're connecting to the right server? I have the 2012 tools installed on my machine and Profiler works fine against 2005. – Jon Seigel Jan 4 '13 at 14:27

It sounds like you might possibly be mistaking a server side trace and SQL Server Profiler which perform very similar functions but work slightly differently and store data in different places.

Show us your code on how you started the trace, or tell us what steps you took. You could also look at the following:

Server Side Trace:

Profiler (not recommended unless you are collecting a small amount of data):

Is the problem that when you start up SQL Server Profiler and start collecting data nothing populates the screen?

share|improve this answer

Your Answer


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.