trace a database

hi can anyone tell me how to put on a database trace using sql2005 please..

thanks
ac_davis2002Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sachinpatil10dCommented:
Try this

Trace properties > Events Selection tab > select show all columns. Now under column filters, you should see the database name. Enter the database name for the Like section and you should see traces only for that database.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tigin44Commented:
trace operation look for many parameters. which ones do you want to trace?
you can start the trace operation from within the Management Studio by choosing SQL Profiler menu.
once you started the trace operation you should connect to the database you want to trace and then choose the appropriate metrics and define the required filters and then run the trace. The trace operation consumes system resources and should used as needed.
0
Anuradha GoliSystems Development / Support SpecialistCommented:
Try using SQL Profiler and select the database you wanted to trace and set any filters if needed.
0
ac_davis2002Author Commented:
Thanks, i have opened the profiler but can see where you select the database you want to trace?
0
Anuradha GoliSystems Development / Support SpecialistCommented:
Hi You can follow the steps shown in picture
select show all columns
click column filters
select databasename
In like enter databasename within% as '%DBNAME%'
flow of profiler to filter databasename
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.