Answer Posted / hajee

select sysdate from dual

Mention a few common trace flags used with sql server?

879

---

Explain multiserver query

959

---

on line cluster can we make if yes tell me the procedure

1974

---

What are the export options of ssrs?

165

---

Is truncate a dml command?

887

---

What are transactions and its controls?

1002

---

In how many ways you can invoke ssrs reports?

131

---

How to delete an existing database user?

967

---

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

954

---

What are subqueries in sql server?

1062

---

What is the difference between for auto and for nested?

930

---

What are a scheduled jobs?

907

---

A trigger can reference objects outside the current database? State true or false.

942

---

Explain the phases a transaction has to undergo?

985

---

What is the tcp/ip port on which sql server runs?

1055

---