Answer Posted / madan

sp_grantlogin'Domainname\loginname'

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

976

---

Explain different types of self contained sub query?

1038

---

Write a query to find 5th highest amount paid from the customer table.

934

---

Explain alternate key, candidate key and composite key in sql server?

915

---

What is a functions and types in sql server?

1087

---

What are the requirements on sql server network connections?

996

---

What is a mutating table error and how can you get around it?

1050

---

How to view existing indexes on an given table using sp_help?

1139

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

986

---

What is buffer cash in sql server?

1152

---

What is #table in sql server?

1041

---

Explain the dbcc pintable command when would you use it?

920

---

What is fill factor and pad index?

1012

---

How to locate and take substrings with charindex() and substring() functions?

1016

---

What are views used for?

1014

---