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

Explain what are the authentication modes in sql server?

0 Answers  

---

What are cursors?

8 Answers  

---

Write the syntax for stuff function in an sql server?

0 Answers  

---

How to create user messages with print statements in ms sql server?

0 Answers  

---

How dts is used to extract, transform and consolidate data?

0 Answers  

---

Can anybody explain me cold backup and hot backup?

3 Answers   TCS,

---

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

---

How do clustered indexes store data?

0 Answers  

---

Why people hate cursor?

0 Answers  

---

what is the difference between count(*) and count(1) ?

0 Answers   MCN Solutions,

---

Explain database normalization?

0 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---