How to Run a Query on a Remote SQL Server?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

how would you store your query in an SSRS report or a Database server?

142


Define self join?

813


Suggest a method of joining two tables.

853


What is the difference between dataadapter and datareader?

758


What are the triggers in sql?

774


What is buffer cash and log cache in sql server?

817


How many types of functions are there in sql server?

634


How can sql server instances be hidden?

710


How to automatically create a log when an exception is being received into SQL Server?

952


What is trace flag in sql server?

760


Differentiate between truncate vs delete in mssql?

711


Can group by and orderby be used together?

786


What is cursors?

829


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1095


What is the difference between value type and reference type?

729