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.

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1113

---

Which autogrowth database setting is good?

1096

---

What happens when converting big values to integers?

1059

---

What are character string data types in ms sql server?

1347

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2547

---

What is acid db?

932

---

Differentiate between a having clause and a where clause.

1010

---

What do you mean by the term 'normalization'?

1282

---

How does a profiler work?

994

---

How do I schedule a sql server profiler trace?

1027

---

What are rows and columns?

1064

---

What are the new scripting capabilities of ssms? : sql server management studio

1119

---

Which joins are sql server default?

1069

---

How to test a dml trigger in ms sql server?

1113

---

Explain what are commit and rollback in sql?

982

---