Answer / renu

SQL Server Agent is a Microsoft Windows Service that
executes scheduled administrative tasks called jobs.

It is made up of 3 components :

1)Jobs - Scheduled tasks

2)Alerts - set of actions occur when an event occurs.

3)Operators -People who alerts are sent to

Answer / sabin

Managing all scheduled jobs, monitoring for alerts and
notifying operators

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

What are system databases into sql server (2005/2008)?

0 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

Explain sp_configure commands, set commands?

3 Answers  

---

What is nolock?

0 Answers  

---

What are trace files?

0 Answers  

---

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

Explain foreign key in sql server?

0 Answers  

---

Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,

---

How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

---

How to include text values in sql statements?

0 Answers  

---