Which stored procedure will you be running to add a linked server?

Which stored procedure will you be running to add a linked
server?

Question Posted / guest

Which stored procedure will you be running to add a linked server?..

Answer / guest

sp_addlinkedserver, sp_addlinkedsrvlogin

Is This Answer Correct ?

4 Yes

1 No

More SQL Server Interview Questions

Can one drop a column from a table?

How do I find query history in sql server?

What is a result set object returned by mssql_query()?

What is the fastest way to permanently delete a 1 million row table named customers?

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

Can we insert data into view sql server?

Define views.

What are the difference between primary keys and foreign keys?

Define primary key?

What are three SQL keywords used to change or set someone?s permissions?

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

Which virtual table does a trigger use?

For more SQL Server Interview Questions Click Here