Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can sql server be linked with other servers like oracle?
What is function of master database?
What is the exact numeric data type in sql?
List out a number of the wants to setup a SQL Server failover cluster?
What is the difference RDBMS and Graph Database?
Write a SQL query to make a column as unique?
What is a full text index?
What are sub reports and how to create them?
what's the difference between a primary key and a unique key? : Sql server database administration
What is SQL Azure?
What is the current limitation of the size of SQL Azure DB?
What are the different types of stored procedures?
How many replicas are maintained for each sql azure db?
What is resource governor in sql server?
What is partition, how will you implement it? : sql server analysis services, ssas
