Answer / debapriya

These are the three different security model connecting to
Linked Server.

In Self Mapping SQL Server tries to connect to the linked
server using current users credentials(UserId and PWD).

In Delegation SQL Server tries to connect to the Linked
server by using the Windows credential.

In Remote Credentials the Local login credential is mapped
into remote credential.

What is the difference between Procedure and Function

4 Answers   Accenture, Nagarro, TCS,

---

What are distinctive joins find as a part of sql?

0 Answers  

---

How do I find the sql server database version?

0 Answers  

---

Can we install sql server 2016 on windows 7?

0 Answers  

---

Explain syntax for disabling triggers?

0 Answers  

---

where can you add custom error messages to sql server? : Sql server administration

0 Answers  

---

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

---

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,

---

What is a cursor, index in sql?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

Which trace flags are enabled in sql server?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---