Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

to open a sql server 2005 .trc file

  
   Database Forums (Home) -> Tools RSS
Next:  Where not exists  
Author Message
playplay1978

External


Since: Oct 31, 2008
Posts: 2



(Msg. 1) Posted: Fri Oct 31, 2008 2:52 am
Post subject: to open a sql server 2005 .trc file
Archived from groups: microsoft>public>sqlserver>tools (more info?)
Hi.

I have a .trc file created by SQL Profiler of SQL Server 2005.

I need to open the .trc file in another machine which has only SQL
Server 2005 Express Edition but SQL Profiler installed. Is there any
free open source software which i can use to open the .trc file?

Thanks.

 >> Stay informed about: to open a sql server 2005 .trc file 
Back to top
Login to vote
Erland Sommarskog2

External


Since: May 30, 2004
Posts: 1649



(Msg. 2) Posted: Fri Oct 31, 2008 3:58 pm
Post subject: Re: to open a sql server 2005 .trc file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
playplay1978 ( ) writes:
> I have a .trc file created by SQL Profiler of SQL Server 2005.
>
> I need to open the .trc file in another machine which has only SQL
> Server 2005 Express Edition but SQL Profiler installed. Is there any
> free open source software which i can use to open the .trc file?

Not exactly source, but free. To wit, SQL Express 2005 itself. Checkout
fn_trace_gettable in Books Online.


--
Erland Sommarskog, SQL Server MVP, esquel.DeleteThis@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 >> Stay informed about: to open a sql server 2005 .trc file 
Back to top
Login to vote
playplay1978

External


Since: Oct 31, 2008
Posts: 2



(Msg. 3) Posted: Sun Nov 02, 2008 7:55 pm
Post subject: Re: to open a sql server 2005 .trc file [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Yes, Erland.

I can use fn_trace_gettable. Your help has reduced me days of works!
Great!

On Nov 1, 6:58 am, Erland Sommarskog wrote:
> playplay1978 ( ) writes:
> > I have a .trc file created by SQL Profiler of SQL Server 2005.
>
> > I need to open the .trc file in another machine which has only SQL
> > Server 2005 Express Edition but SQL Profiler installed. Is there any
> > free open source software which i can use to open the .trc file?
>
> Not exactly source, but free. To wit, SQL Express 2005 itself. Checkout
> fn_trace_gettable in Books Online.
>
> --
> Erland Sommarskog, SQL Server MVP, esq... DeleteThis @sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: to open a sql server 2005 .trc file 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Management Studio - Open File - I was hoping this would be worked out with RTM, but it does not look like it. I want to open a .sql file from disk in my current window. Whenever I try to open a file managment studio opens it into a new tab, prompts me for my connection info, and..

Open SQL file using SQL 2005 Management Studio - Everytime when I open .SQL file using SQL 2005 management Studio, it ask me about connection info. Is there any way to use the previous one like SQL 2000? For example, first time when I open .SQL file, I put connection info, and if I open another .SQL...

Open a file in Existing Query window ( SQL 2K5 )... -

SQL Server 2005 - Server side trace script - Hi, I have been beating my head against the wall on this one, and am hoping someone can point out what I am doing wrong here. I am trying to set up a trace (using script) that will tracks all the "RPC:Completed" events and give me some of t...

debugging in sql server 2005 - Can you 'step' through code in sql server 2005 express like you can in visual studio.net 2005? I want to be able to debug code on my own workstation since my company does not have a 'test' sql server for me to use. Does the developer's version of sql....
   Database Forums (Home) -> Tools All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]