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 to call a function from a stored procedure in SQL Server ?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What does sql server mean?
What are the joins in sql server? : sql server database administration
What is the difference between for auto and for nested?
What are drillthrough reports?
What do we have to check in database testing?
what is create database syntax? : Sql server database administration
What does Master database contains?
Write SQL queries on Self Join and Inner Join.
Tell me what do we need queues in sql service broker?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
Explain what is the function of sql server agent windows service?
What are the mathematical functions supported by sql server 2005?
How do you delete a data source?