Create a new trace and choose the following events and columns:
Add the column filters accordingly.
Run the trace and script it:
|ABOUT THE AUTHOR:|
Michelle Gutzait works as a senior databases consultant for ITERGY International Inc., an IT consulting firm specializing in the design, implementation, security and support of Microsoft products in the enterprise. Gutzait has been involved in IT for 20 years as a developer, business analyst and database consultant. For the last 10 years, she has worked exclusively with SQL Server. Her skills include database design, performance tuning, security, high availability, disaster recovery, very large databases, replication, T-SQL coding, DTS packages, administrative and infrastructure tools development, reporting services and more.|
Copyright 2007 TechTarget
More on SearchSQLServer.com
This was first published in March 2007