Explorer won't open SQL Profiler's trace data file (.trc) on WinXP

The problem that I'm having is that I cannot launch SQL Profiler by
double-clicking the .TRC file type on any maching running Windows XP with
SP2. When I try, I get the "Open With" dialog, but Profiler isn't in the
list and can't be added.
We have SQL 2000 SP3a Client Tools installed on machines with Win2k SP3,
WinXP SP1a and WinXP SP2. Launching Profiler this way works on any machine
that is not WinXP SP2.
I have this problem on machines that were upgraded to SP2, and on machines
that came with SP2 preinstalled. So it doesn't matter whether the SQL Client
Tools were installed before or after.
All of my WinXP SP2 machines already have the SQL Server 2000 hotfix #
810185 installed so I do not know if this problem occurred without it.
Jack Wilson wrote:
> The problem that I'm having is that I cannot launch SQL Profiler by
> double-clicking the .TRC file type on any maching running Windows XP
> with SP2. When I try, I get the "Open With" dialog, but Profiler
> isn't in the list and can't be added.
> We have SQL 2000 SP3a Client Tools installed on machines with Win2k
> SP3, WinXP SP1a and WinXP SP2. Launching Profiler this way works on
> any machine that is not WinXP SP2.
> I have this problem on machines that were upgraded to SP2, and on
> machines that came with SP2 preinstalled. So it doesn't matter
> whether the SQL Client Tools were installed before or after.
> All of my WinXP SP2 machines already have the SQL Server 2000 hotfix #
> 810185 installed so I do not know if this problem occurred without it.
This is an interesting problem. One that I cannot figure out. For some
reason, even though the TRC file extension is correctly associated with
Profiler.exe, and Profiler.exe is in the Path, it will not open and
seems to think it's a Visual Studio 6 file type. Alas, all is not
lost...
While I cannot identify the problem, you can easily address it by
opening Explorer, selecting the Tools - Folder Options menu option.
Click on File Types and find TRC. Click the Advanced button and then
open up the "Open" action. It should read something like "profiler.exe
/f%1". Click on Browse and locate the Profiler.exe application in the
SQL Server BINN folder. You should now see the full path and an action
that reads as follows:
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\profiler.exe" /F%1
Then it should work.
David Gugick
Quest Software
www.imceda.com
www.quest.com