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 indexers?

0 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

---

We need to perform what steps in the following order to work with a cursor?

0 Answers  

---

What are pessimistic lock and optimistic lock?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

Tell me what do we need queues in sql service broker?

0 Answers  

---

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

---