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

How to call a function from a stored procedure in SQL Server ?

952


Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1010


What does sql server mean?

974


What are the joins in sql server? : sql server database administration

961


What is the difference between for auto and for nested?

931


What are drillthrough reports?

141


What do we have to check in database testing?

967


what is create database syntax? : Sql server database administration

1052


What does Master database contains?

1083


Write SQL queries on Self Join and Inner Join.

1071


Tell me what do we need queues in sql service broker?

925


John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

884


Explain what is the function of sql server agent windows service?

941


What are the mathematical functions supported by sql server 2005?

996


How do you delete a data source?

953