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.

I've installed SQL Server 2008 R2 Express edition on my Win 7 notebook. Using since an Express edition this doesn't have SQL Server profiler enabled. Thus it's hard for me to debug my SQL Server 2005 applications.

I have a license for SQL Server 2005 (32 bit) and when I tried to install the client tools it gave a "known compatibility" error message. Is it possible to install SQL Server 2005 client tools (for 32 bit) only in the same machine?

Below is list of software on my machine

  • Windows 7
  • SQL Server 2008 R2 Express edition
  • Visual Studio 2010

Can any one advise.

thanks a zillion

share|improve this question

migrated from stackoverflow.com Dec 28 '12 at 9:11

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

    
So what was MS's solution to whatever known compatibility issue it was? –  Tony Hopkinson Dec 28 '12 at 3:21

1 Answer 1

I doubt you can use the SQL Server 2005 client tools for SQL Server 2008 R2. But if your main issue is the inability to use profiler, I suggest just running server-side traces instead. You don't get the fancy GUI, but you can still see all the same data.

Running a trace without profiler: SQL Server Performance Statistics Using a Server Side Trace

Note, one thing you won't be able to do with server-side tracing is to replay a trace.

share|improve this answer

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.