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
Best Answer
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.