Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

any one can explain
Self mapping
Delegation
Remote Credentials

Question Posted / laxman


any one can explain Self mapping Delegation Remote Credentials..

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.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Does partitioning improve performance?

0 Answers  

what is the sql equivaent of the dataset relation object ?

0 Answers  

what is create database syntax? : Sql server database administration

0 Answers  

What is an active database?

0 Answers   HCL,

what is mean by constraints in sql?

5 Answers   Granada, IBM,

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

How to turn off warning messages during php execution?

0 Answers  

tell me the disaster recovery plan

0 Answers   Microsoft,

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

What is the difference between Clustered and Non-Clustered Index?

0 Answers  

How does a profiler work?

0 Answers  

what is a self join? Explain it with an example? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories