Answer Posted / Sadaf Naz
To schedule a SQL Server Profiler trace, follow these steps:
1. Open SQL Server Management Studio (SSMS).
2. In Object Explorer, connect to the instance of SQL Server.
3. Right-click on the Trace Files node under SQL Server Logs and select New Trace..."
4. Configure your trace properties, events, filters, and actions.
5. Click on the Schedule tab and set a schedule for your trace.
6. Click OK to create the scheduled trace.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is clustered index
What are the source of constraints?
Why we use the openxml clause?
what is the difference between openrowset and openquery?
What is a scheduled job or what is a scheduled task?
What are the different SQL Server Versions you have worked on?
What is the difference between for xml raw and for xml auto?
List out the different types of locks available in sql server?
Explain “row_number()” in sql server with an example?
What is in place upgrade in sql server?
What is a view in sql?
How do I find query history in sql server?
What are the different types of subquery?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are the different subsets of sql?
