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 about service Broker functions?

0 Answers  

---

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  

---

Explain a join?

0 Answers  

---

How to create function without parameter in sql server?

0 Answers  

---

how many type of indexing in database?

0 Answers   IBM,

---

---

What are subqueries in sql server? Explain its properties.

0 Answers  

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,

---

How to enable/disable indexes?

0 Answers  

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---

List the different types of joins?

0 Answers  

---

What is the stuff and how does it differ from the replace function?

0 Answers  

---