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
How does using a separate hard drive for several database objects improves performance right away?
How to Insert multiple rows with a single insert statement?
What is sql azure database?
Difference between Sql server reporting services and Crystal reports?
What are a scheduled jobs or what is a scheduled tasks?
Explain log shipping and mention its advantages.
Explain what is public role in sql server?
Explain atomicity?
What is the difference between a "where" clause and a "having" clause?
What is an indexing technique?
Give the query of getting last two records from the table in SQL SERVER?
What is sql server schema compare? How we can compare two database schemas?
What is policy based management (pbm)? : sql server database administration
What is the Main Difference between ACCESS and SQL SERVER?
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?