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
How to verify a user name with sqlcmd tool?
How do you make a trace?
Does group by or order by come first?
What is the current pricing model of SQL Azure?
what is a correlated sub-query? : Sql server database administration
What are relationships and mention different types of relationships in the dbms
What do you mean by sql server 2005 express management tools?
How many columns can we include on clustered index ?
Can a trigger be created on a view?
Explain what is lock escalation?
What are the two authentication modes in sql server?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
List the various tools available for performance tuning?
What is the query and subquery?
What is trace flag in sql server?
