Answer Posted / devipriyanka

Types of Triggers

* DML(data manipulation language) triggers (SQL Server
2000- 80.0)
o AFTER triggers (Only Tables)
o INSTEAD OF triggers (Tables or Views)
* DDL(data definition language) triggers (SQL Server
2005- 90.0)
* SQLCLR triggers (SQL Server 2005- 90.0)

After removing a table from database, what other related objects have to be dropped explicitly?

997

---

Where do we use trace frag?

967

---

Explain activity monitors

999

---

Explain what are the different index configurations a table can have?

1036

---

explain different types of constraints? : Sql server database administration

913

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2713

---

How to convert numeric expression data types using the cast() function?

1001

---

What is the use of builtinadministrators group in sql server? : sql server security

964

---

How do you delete a data source?

951

---

how will add additional conditions in sql?

1010

---

What is normalization according to you and explain its different levels?

895

---

what is hash nonclustered index

906

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1057

---

What is federation member?

114

---

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

939

---