Answer / 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.

How to check table values in sql server?

1 Answers  

---

How to see existing views in ms sql server?

1 Answers  

---

How do you create a data source?

1 Answers  

---

Explain about link server in sql server?

1 Answers  

---

What is a view and what are its advantages?

1 Answers  

---

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---

How to find table changes in sql server?

1 Answers  

---

What is the maximum number of index per table?

1 Answers  

---

Find nth lowest salary or get nth lowest salary?

1 Answers  

---

How to add additional conditions in SQL?

1 Answers   Amdocs,

---

Why I am getting this error when renaming a database in ms sql server?

1 Answers  

---

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

---