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

Explain the dbcc pintable command when would you use it?

720


What is sql language?

759


What is a dbms wizard?

806


How to get a list of columns in a view using the "sp_columns" stored procedure?

838


Explain what is meant by replication of database?

763


How do database indexes work?

782


What are sql dirty pages?

798


What is raiseerror? What is raiseerror?

864


What is dirty page?

768


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2716


What does the on update no action do?

796


Explain what is the difference between a local and a global temporary table?

771


How do I manually uninstall an instance of sql server 2016?

777


Explain in details security in SQL azure?

117


What is query cost in sql server?

790