Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 Extended user-defined?

959


Explain about nested stored procedure?

1027


How to edit table in sql server 2017?

926


What is the user of Primary key?

985


What happens if null values are involved in datetime operations?

975


How to store and query spatial data?

993


What is normalization of database?

1105


How to set database to be read_only in ms sql server?

1010


How to Update from select query in sql server?

1060


How to create indexed view?

1045


It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1041


What is subquery? Explain the properties of a subquery?

988


What the different components of Replication and what is their use?

1068


Explain timestamp datatype?

969


whats new about truncate in sql server 2008?

2502