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 scalar functions?

0 Answers  

---

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

---

what do you understand by change data capture?

0 Answers  

---

Can we take the full database backup in log shipping?

0 Answers  

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

---

What is proper subset of candidate key?

0 Answers  

---

Do you know what are the reporting services components?

0 Answers  

---

What is the process of normalising?

0 Answers  

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  

---

Explain datetimeoffset data type in sal server 2008?

0 Answers  

---

What is database architecture? : SQL Server Architecture

0 Answers  

---