Answer Posted / naveengoud

In SQL Server 2008 we have an Option called DATABASE MAIL, in earlier editions it is referred as SQL Mail.

using DATABASE MAIL we can send  notifying mails to the users/administrator.

What is co-related sub query?

1007

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2003

---

How to create a simple table to test triggers in ms sql server?

962

---

what is bit datatype? : Sql server database administration

897

---

What is advantage data architect?

905

---

How can you know if the row fetched from cursor is still valid in underlying table?

986

---

What are different types of table joins?

990

---

what are the types of indexes? : Sql server database administration

1097

---

what's sql server? : Sql server database administration

979

---

What is molap and its advantage? : sql server analysis services, ssas

968

---

How would you choose between a clustered and a non-clustered index?

951

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1008

---

What is a raid and what are different types of raid configurations?

1248

---

What is a benefit of using an after insert trigger over using a before insert trigger?

967

---

What is the difference between dataadapter and datareader?

979

---