double clicking a trace file does not bring any results

I installed SP4 and when i double click on a sql trace file that i had the
profiler write to, just opens up Profiler and does not display the saved
results.
But when i go File-> Open and select the trace file, it populates the
results. So I dont know why the double clicking does not populate it ? Is it
a bug ? It used to work when i had Sp3a but after installing Sp4, it acts as
such
Has anyone seen this ?Hassan wrote:
> I installed SP4 and when i double click on a sql trace file that i
> had the profiler write to, just opens up Profiler and does not
> display the saved results.
> But when i go File-> Open and select the trace file, it populates the
> results. So I dont know why the double clicking does not populate it
> ? Is it a bug ? It used to work when i had Sp3a but after installing
> Sp4, it acts as such
> Has anyone seen this ?
I've found that the "Action" created for the TRC files by the installer
does not set this up properly. From Explorer, Click on Tools | Folder
Options - File Types. Locate the TRC file extension in the list. Click
the Advanced button. Click New to create a new action. Call it "Open in
Profiler" with the following properties:
Action: "Open in Profiler"
App used to perform action: "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\profiler.exe" /F%1
Use DDE: Checked
Application: profiler
Topic: System
Press OK and then click the Set Default button to make this the default
action.
You should be good to go.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Still the same.. No luck.. :-(
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23nXr6wtvFHA.612@.TK2MSFTNGP10.phx.gbl...
> Hassan wrote:
>> I installed SP4 and when i double click on a sql trace file that i
>> had the profiler write to, just opens up Profiler and does not
>> display the saved results.
>> But when i go File-> Open and select the trace file, it populates the
>> results. So I dont know why the double clicking does not populate it
>> ? Is it a bug ? It used to work when i had Sp3a but after installing
>> Sp4, it acts as such
>> Has anyone seen this ?
> I've found that the "Action" created for the TRC files by the installer
> does not set this up properly. From Explorer, Click on Tools | Folder
> Options - File Types. Locate the TRC file extension in the list. Click the
> Advanced button. Click New to create a new action. Call it "Open in
> Profiler" with the following properties:
> Action: "Open in Profiler"
> App used to perform action: "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\profiler.exe" /F%1
> Use DDE: Checked
> Application: profiler
> Topic: System
> Press OK and then click the Set Default button to make this the default
> action.
> You should be good to go.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Hassan wrote:
> Still the same.. No luck.. :-(
I use it and it works fine here. Please check the Action against what I
posted to make sure it was typed in correctly. Also make sure it's the
default action. Running SP3a and SP4 versions of SQL Server.
David Gugick
Quest Software
www.imceda.com
www.quest.com