Answer / Subhas Chandra Srivastava

A Linked Server in SQL Server allows you to access data residing on another database or data source as if it were a local table. This can be useful for joining data from multiple sources.nnTo create a linked server, you would use the sp_addlinkedserver stored procedure. Here's an example:nEXEC sp_addlinkedserver @server = N'MyLinkedServer', @srvproduct=N'ODBC Driver 13 for SQL Server', @provider=SQLNCLI13, @datasrc=<Your_Remote_Database_Server>, @provstr=<Your_Connection_String>nAfter creating the linked server, you can reference remote tables using four-part names: [linked_server._schema._table].

How do you make a trace?

1 Answers  

---

What is an indice?

1 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

What do you understand by user-defined function in the sql server?

1 Answers  

---

How to provide login information for a new odbc dsn?

1 Answers  

---

If a stored procedure is taking a table data type, how it looks?

2 Answers  

---

What is 3nf normalization form?

1 Answers  

---

What is scrollable cursor?

1 Answers  

---

How do I setup a local sql server database?

1 Answers  

---

Which sql server table is used to hold the stored procedure scripts?

1 Answers  

---

What is self contained scalar sub query?

1 Answers  

---

can an automatic recovery be initiated by a user? : Sql server administration

1 Answers  

---