what are three different authentications to connect linked

what are three different authentications to connect linked servers?..

Answer / vidhya sagar

Self mapping
Remote Credentials

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

How do you Implement SSIS Packages in your Project?

0 Answers  

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

what is DTS what are tasks available

1 Answers   Wipro,

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

what is trigger

1 Answers   NIIT, CarrizalSoft Technologies,

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

where do you use Isolations?give me some exmpale?

1 Answers