Answer Posted / vani

version 6.5 in 1995
version 7.0 in 1999
version sql 2000 in 2000
version sql2005 in nov 2005
verson 2008 in Q3 2008

How do I run a trace in sql server?

682

---

How to disable triggers using "disable trigger"?

779

---

How many servers can we create in a single subscription?

156

---

Working with TLogs

1599

---

How to set the current database in ms sql server?

719

---

---

Does a sql server 2005 select statement require a from?

774

---

Explain microsoft sql server functions?

765

---

Explain error and transaction handling in sql server?

679

---

What is the default server name for sql server?

803

---

How you can get a list of all the table constraints in a database?

677

---

How to select all columns of all rows from a table with a select statement in ms sql server?

747

---

What is the difference between row_number and dense_rank?

596

---

Write a sql query to display the current date?

824

---

What is the purpose of data source?

709

---

What is difference between join and natural join?

643

---