any one can explain
Self mapping
Delegation
Remote Credentials
Answer Posted / 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 View All Answers
How do I start sql server agent automatically?
What are basics of policy management?
What are .mdf files?
Can you name some of the dml commands in sql?
What is the difference between a function and a stored procedure?
What is the function of sql server agent windows service?
Explain the properties of the relational tables?
What is cursors? And what are the different types of cursor?
What is difference between standardization and normalization?
What are entities and relationships?
What structure can you implement for the database to speed up table reads?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
Explain the stored procedure?
How can I check that whether automatic statistic update is enabled or not?