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

Detail about query optimizer?

0 Answers  

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

0 Answers  

---

How many types of keys are there?

0 Answers  

---

Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,

---

---

can a table be moved to different filegroup? : Sql server administration

0 Answers  

---

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

---

How to enforce security in sql server? : sql server security

0 Answers  

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

0 Answers  

---

How can we get count of the number of records in a table?

0 Answers  

---

What command would you use to create an index?

0 Answers  

---

Where is trigger in sql server?

0 Answers  

---