Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / Vinayak Kumar Arya
To use a Linked Server in SQL Server, follow these steps:n1. Open Object Explorer and navigate to SQL Server Network Aliases.n2. Right-click on SQL Server Network Aliases and select New Linked Server.n3. In the Linked Server properties dialog box, provide a name for the linked server, its provider, and data source details.n4. Choose the security options (SQL Server Authentication or Windows Authentication).n5. Click OK to create the linked server.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to provide default values to function parameters?
How to rebuild the master database?
What is an indexed view?
What is the difference between for xml raw and for xml auto?
How can you append an identity column to a temporary table?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the different types of subquery?
Is it possible to have clustered index on separate drive from original table location?
Explain “row_number()” in sql server with an example?
How to convert numeric expression data types using the cast() function?
Can we do dml on views?
What is normalization and what are the advantages of it?
What is clustered index
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Disadvantages of the indexes?
