How to Run a Query on a Remote SQL Server?
Answers were Sorted based on User's Feedback
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 |
Answer / guest
Use the OpenRowSet Function to Run a Query on a Remote SQL
Server.
Is This Answer Correct ? | 1 Yes | 4 No |
What is the importance of concurrency control?
What is apply operator in sql?
Which system tables contain information on privileges granted and privileges obtained
what's the maximum size of a row? : Sql server database administration
Explain the difference between HTTP and HTTPS in database?
What is a group function explain with an example?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How to find which stored procedure is currently running in sql server?
What is 'write-ahead log' in sql server 2000 ?
What is the maximum size of sql server database?
How to check table values in sql server?
what is the difference between a primary key and a unique key? : Sql server database administration