dbTalk Databases Forums  

to open a sql server 2005 .trc file

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools to open a sql server 2005 .trc file

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss to open a sql server 2005 .trc file in the microsoft.public.sqlserver.tools forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
playplay1978
 
Posts: n/a

Default Re: to open a sql server 2005 .trc file - 11-02-2008 , 09:55 PM





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 <esq... (AT) sommarskog (DOT) se> wrote:
Quote:
playplay1978 (albertl... (AT) gmail (DOT) com) 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... (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx


Reply With Quote
  #12  
Old   
playplay1978
 
Posts: n/a

Default Re: to open a sql server 2005 .trc file - 11-02-2008 , 09:55 PM





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 <esq... (AT) sommarskog (DOT) se> wrote:
Quote:
playplay1978 (albertl... (AT) gmail (DOT) com) 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... (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx


Reply With Quote
  #13  
Old   
playplay1978
 
Posts: n/a

Default Re: to open a sql server 2005 .trc file - 11-02-2008 , 09:55 PM


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 <esq... (AT) sommarskog (DOT) se> wrote:
Quote:
playplay1978 (albertl... (AT) gmail (DOT) com) 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... (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx


Reply With Quote
  #14  
Old   
playplay1978
 
Posts: n/a

Default Re: to open a sql server 2005 .trc file - 11-02-2008 , 09:55 PM


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 <esq... (AT) sommarskog (DOT) se> wrote:
Quote:
playplay1978 (albertl... (AT) gmail (DOT) com) 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... (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx


Reply With Quote
  #15  
Old   
playplay1978
 
Posts: n/a

Default Re: to open a sql server 2005 .trc file - 11-02-2008 , 09:55 PM


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 <esq... (AT) sommarskog (DOT) se> wrote:
Quote:
playplay1978 (albertl... (AT) gmail (DOT) com) 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... (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx


Reply With Quote
  #16  
Old   
playplay1978
 
Posts: n/a

Default Re: to open a sql server 2005 .trc file - 11-02-2008 , 09:55 PM


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 <esq... (AT) sommarskog (DOT) se> wrote:
Quote:
playplay1978 (albertl... (AT) gmail (DOT) com) 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... (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx


Reply With Quote
  #17  
Old   
playplay1978
 
Posts: n/a

Default Re: to open a sql server 2005 .trc file - 11-02-2008 , 09:55 PM


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 <esq... (AT) sommarskog (DOT) se> wrote:
Quote:
playplay1978 (albertl... (AT) gmail (DOT) com) 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... (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx


Reply With Quote
  #18  
Old   
playplay1978
 
Posts: n/a

Default Re: to open a sql server 2005 .trc file - 11-02-2008 , 09:55 PM


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 <esq... (AT) sommarskog (DOT) se> wrote:
Quote:
playplay1978 (albertl... (AT) gmail (DOT) com) 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... (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx


Reply With Quote
  #19  
Old   
playplay1978
 
Posts: n/a

Default Re: to open a sql server 2005 .trc file - 11-02-2008 , 09:55 PM


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 <esq... (AT) sommarskog (DOT) se> wrote:
Quote:
playplay1978 (albertl... (AT) gmail (DOT) com) 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... (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx


Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top