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
What is difference between clustered index and non clustered index?
How to create a trigger for insert only?
Ms sql server index?
Explain contrast amongst grouped and non-bunched records?
What is the security principal at the database level that represents your session?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
what is a deadlock? : Sql server database administration
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Explain magic tables in sql server?
How to convert numeric values to integers in ms sql server?
How do you Implement SSIS Packages in your Project?
List down some advantages of sql stored procedure?
What are various ways to enhance the ssrs report?
How to find the list of fixed hard drive and free space on server?
Do you know what is sql service broker?