1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How to Run a Query on a Remote SQL Server?

Question Posted / guest

Answers were Sorted based on User's Feedback



How to Run a Query on a Remote SQL Server?..

Answer / vinod

By Using linked server we can get data from remote servers, and we can fire a query on remote server. we need to use three part naming conventions for this.

servername.databasename.dbo.tablename

Is This Answer Correct ?    4 Yes 1 No

How to Run a Query on a Remote SQL Server?..

Answer / guest

Use the OpenRowSet Function to Run a Query on a Remote SQL
Server.

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More SQL Server Interview Questions

How to count duplicated values in a column in ms sql server?

0 Answers  

How to run queries with sql server management studio express?

0 Answers  

What is the distinction amongst delete and truncate?

0 Answers  

How to send email from database?

0 Answers  

Explain isolation levels that sql server supports?

0 Answers  




How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

What is the difference between the application object and session object?

0 Answers  

Why would you call update statistics?

0 Answers  

What are the two modes of authentication in sql server?

0 Answers  

How to access the inserted record of an event?

0 Answers  

How to convert a table data in XML format in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories