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.

How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  

---

Are connections to sql server encrypted?

0 Answers  

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

What is tempdb database? : SQL Server Architecture

0 Answers  

---

How to avoid cursors?

3 Answers   CarrizalSoft Technologies, HP,

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

What are sql server functions?

0 Answers  

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

---

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---