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 are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

how to rest identity columns in sql server

3 Answers   Matrix,

---

What is left outer join in sql server joins?

0 Answers  

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---

---

Mention the different authentication modes in sql server.

0 Answers  

---

What is openrowset sql server?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

How important do you consider cursors or while loops for a transactional database?

0 Answers  

---

How and why use sql server?

0 Answers  

---

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

---

What are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---