any one can explain
Self mapping
Delegation
Remote Credentials
- 1 Answers
- 4879 Views
- I also Faced
- E-Mail Answers
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
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
How will you decide the active and passive nodes?
When would you prefer to have a minimum number of indexes?
What kind of problems occurs if we do not implement proper locking strategy?
How do you migrate data from mssql server to azure?
How to locate and take substrings with charindex() and substring() functions?
How to check table values in sql server?
Which tcl commands are available on the sql server?
What is the data type of time?
What is the difference between char and varchar2 datatype in sql?
How the authentication mode can be changed?
How many replicas are maintained for each sql azure db?
What is a select query statement in ms sql server?
Why do we use functions?
Would you store your query in a ssrs report or a database server? State the reason why?
