 | |
Using Profiler to capture database name and object
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Using Profiler to capture database name and object -
12-02-2008
, 04:28 PM
|
I appoligize for not stating that I am using SS2000, so the fine query below does not work. I am trying to use profiler to do a similar thing. My gut feeling is that since all the "name" fields in profiler are always blank that I just have to live with it. But I still need to report to my boss which databases and tables are being accessed. |
To get the tables, you will have to parse the queries.
You are probably better off running a server-side trace and then use
fn_trace_gettable to read the trace file. You can easily get the script
for a server-side trace by exporting what you have in Profiler.
--
Erland Sommarskog, SQL Server MVP, esquel (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
#22
| |||
| |||
|
|
I appoligize for not stating that I am using SS2000, so the fine query below does not work. I am trying to use profiler to do a similar thing. My gut feeling is that since all the "name" fields in profiler are always blank that I just have to live with it. But I still need to report to my boss which databases and tables are being accessed. |
To get the tables, you will have to parse the queries.
You are probably better off running a server-side trace and then use
fn_trace_gettable to read the trace file. You can easily get the script
for a server-side trace by exporting what you have in Profiler.
--
Erland Sommarskog, SQL Server MVP, esquel (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
#23
| |||
| |||
|
|
I appoligize for not stating that I am using SS2000, so the fine query below does not work. I am trying to use profiler to do a similar thing. My gut feeling is that since all the "name" fields in profiler are always blank that I just have to live with it. But I still need to report to my boss which databases and tables are being accessed. |
To get the tables, you will have to parse the queries.
You are probably better off running a server-side trace and then use
fn_trace_gettable to read the trace file. You can easily get the script
for a server-side trace by exporting what you have in Profiler.
--
Erland Sommarskog, SQL Server MVP, esquel (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
#24
| |||
| |||
|
|
I appoligize for not stating that I am using SS2000, so the fine query below does not work. I am trying to use profiler to do a similar thing. My gut feeling is that since all the "name" fields in profiler are always blank that I just have to live with it. But I still need to report to my boss which databases and tables are being accessed. |
To get the tables, you will have to parse the queries.
You are probably better off running a server-side trace and then use
fn_trace_gettable to read the trace file. You can easily get the script
for a server-side trace by exporting what you have in Profiler.
--
Erland Sommarskog, SQL Server MVP, esquel (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
#25
| |||
| |||
|
|
I appoligize for not stating that I am using SS2000, so the fine query below does not work. I am trying to use profiler to do a similar thing. My gut feeling is that since all the "name" fields in profiler are always blank that I just have to live with it. But I still need to report to my boss which databases and tables are being accessed. |
To get the tables, you will have to parse the queries.
You are probably better off running a server-side trace and then use
fn_trace_gettable to read the trace file. You can easily get the script
for a server-side trace by exporting what you have in Profiler.
--
Erland Sommarskog, SQL Server MVP, esquel (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
#26
| |||
| |||
|
|
I appoligize for not stating that I am using SS2000, so the fine query below does not work. I am trying to use profiler to do a similar thing. My gut feeling is that since all the "name" fields in profiler are always blank that I just have to live with it. But I still need to report to my boss which databases and tables are being accessed. |
To get the tables, you will have to parse the queries.
You are probably better off running a server-side trace and then use
fn_trace_gettable to read the trace file. You can easily get the script
for a server-side trace by exporting what you have in Profiler.
--
Erland Sommarskog, SQL Server MVP, esquel (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
#27
| |||
| |||
|
|
I appoligize for not stating that I am using SS2000, so the fine query below does not work. I am trying to use profiler to do a similar thing. My gut feeling is that since all the "name" fields in profiler are always blank that I just have to live with it. But I still need to report to my boss which databases and tables are being accessed. |
To get the tables, you will have to parse the queries.
You are probably better off running a server-side trace and then use
fn_trace_gettable to read the trace file. You can easily get the script
for a server-side trace by exporting what you have in Profiler.
--
Erland Sommarskog, SQL Server MVP, esquel (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
#28
| |||
| |||
|
|
I appoligize for not stating that I am using SS2000, so the fine query below does not work. I am trying to use profiler to do a similar thing. My gut feeling is that since all the "name" fields in profiler are always blank that I just have to live with it. But I still need to report to my boss which databases and tables are being accessed. |
To get the tables, you will have to parse the queries.
You are probably better off running a server-side trace and then use
fn_trace_gettable to read the trace file. You can easily get the script
for a server-side trace by exporting what you have in Profiler.
--
Erland Sommarskog, SQL Server MVP, esquel (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
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.