Answer / Aarchi Tyagi

"Automatic Auditing" is a feature in SQL Server 2008 that allows administrators to automatically capture and track database events such as login attempts, schema modifications, data modifications, and more. This feature helps ensure security, compliance, and accountability by providing detailed audit logs of database activity.

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1 Answers  

---

How do you fine the performance tunning?

2 Answers   Accenture,

---

What is a cursor, index in sql?

1 Answers  

---

What is database normalization?

7 Answers   Deloitte, Digicel, JPMorgan Chase, Verifone,

---

List down some advantages of sql stored procedure?

1 Answers  

---

What happens if an integer is too big for int date type?

1 Answers  

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

What is CTE in SQL

1 Answers   Infosys,

---

What is extended stored procedures?

1 Answers  

---

create index a on employee(dno) In this,which index was created?

2 Answers  

---

What is the difference between constraints and triggers?

9 Answers   Wipro,

---