Answer Posted / kavithareddy

delete databasename

What is the difference between a function and a trigger?

563

---

What is service broker?

577

---

how to determine the service pack currently installed on sql server? : Sql server database administration

556

---

What is difference between oltp and olap?

567

---

How do I open port 1433?

512

---

---

What is transaction server isolation?

570

---

What are the advantages of log shipping?

554

---

What are data resources?

499

---

How to change server name in sql server?

554

---

What are the default system databases in sql server 2000?

531

---

How to return the date part only from a sql server datetime datatype?

567

---

Explain few of the new features of sql server 2008 management studio

516

---

What is the difference between coalesce() & isnull()?

526

---

What are the joins in sql server? : sql server database administration

534

---

How to create database with physical files specified in ms sql server?

530

---