Answer Posted / kkk

No foreign key cant take role of primary key

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1188

---

What are the encryption mechanisms in sql server?

1008

---

What are xml indexes?

925

---

what is a self join? Explain it with an example? : Sql server database administration

921

---

Can we return Data from 4(more than 1) tables in stored procedure?

1042

---

What are the rendering extensions of ssrs?

153

---

Explain full-text query in sql server?

979

---

What is the purpose of linked server configuration in sql server?

1020

---

What is default constraint?

976

---

Do you know what is a with(nolock)?

1042

---

How to disable stored procedure sql server?

1587

---

What is collation sensitivity? Explain different types.

993

---

How to Check if table exists in sql server?

1116

---

Explain what are commit and rollback in sql?

910

---

How to use group functions in the select clause in ms sql server?

1035

---