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

What is right outer join in sql server joins?

889


What is bcnf normalization form?

868


What is the use of for clause?

799


What are ddl (data definition language) statements for tables in ms sql server?

795


How to end a stored procedure properly in ms sql server?

782


Please explain what is “asynchronous” communication in sql server service broker?

730


Mention the uses of stored procedures.

753


What are various ways to enhance the ssrs report?

756


How many types of subqueries are there in sql server?

693


What does truncate do?

720


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

766


What is the meaning of sql server?

720


How do I view a script in sql server?

752


How to choose all records from the table?

831


What is the difference between varchar and varchar types?

773