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

Answer Posted / guest

sp_addlinkedserver, sp_addlinkedsrvlogin

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to apply cascading referential integrity in place of triggers?

575


You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

489


Give an example of SQL injection attack ?

570


Do you know what are various aggregate functions that are available?

529


What is a join in sql? What are the types of joins?

526






What is report snapshot in ssrs?

166


What is difference between foreign key and unique key?

554


What are the main differences between #temp tables and @table variables and which one is preferred?

555


What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

598


Can I use sql azure as a backup with log shipping or database mirroring?

136


What is single-user mode?

524


How do I find the sql server instance name?

531


Is it possible in sql table to have more than one foreign key?

618


What is mscorsvw.exe - process - microsoft .net framework ngen?

533


How to Sync Two SQL Azure Databases?

101