Answer / 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.

What is a transactions?

1 Answers  

---

What is the command used to recompile the stored procedure at run time?

1 Answers  

---

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---

In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  

---

What functions can a view be used to performed?

1 Answers  

---

What do you mean by subquery?

1 Answers  

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

1 Answers  

---

does physical index sort data

1 Answers  

---

Is t sql the same as sql server?

1 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1 Answers  

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1 Answers  

---