How to Run a Query on a Remote SQL Server?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does using a separate hard drive for several database objects improves performance right away?

744


How to Insert multiple rows with a single insert statement?

812


What is sql azure database?

198


Difference between Sql server reporting services and Crystal reports?

139


What are a scheduled jobs or what is a scheduled tasks?

702


Explain log shipping and mention its advantages.

817


Explain what is public role in sql server?

843


Explain atomicity?

760


What is the difference between a "where" clause and a "having" clause?

886


What is an indexing technique?

713


Give the query of getting last two records from the table in SQL SERVER?

754


What is sql server schema compare? How we can compare two database schemas?

802


What is policy based management (pbm)? : sql server database administration

783


What is the Main Difference between ACCESS and SQL SERVER?

809


Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

727