Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TMDOSS
Starting Member
33 Posts |
 Posted - 2010-03-09 : 11:18:46
|
| I need to do Profile for our test database. How can and where I need to add database name Pl help |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-09 : 12:06:49
|
| if using profiler, click the column filters button. you can filter on database name, or database idif using sp_trace_create, then u create filters with sp_trace_setfilter http://msdn.microsoft.com/en-us/library/ms174404.aspx |
 |
|
|
TMDOSS
Starting Member
33 Posts |
Posted - 2010-03-09 : 12:36:56
|
| I dont see Database name under column filter. How to add |
|
|
|
namman
Constraint Violating Yak Guru
285 Posts |
Posted - 2010-03-09 : 13:20:14
|
| I dont see Database name under column filter. How to addClick on General - > Using the template : select proper template (for example, blank).ThenClick on Evens Selection, you will see database columnIf you still want to use a specific template and do not see Database column, click on Show all columns, you will see all columns you need |
|
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-03-10 : 05:53:41
|
| Also check the 'Show all Columns' check box. This will allow all columns to be filtered by. |
|
|
|
|
|
|
SQL Profile for database only