What is a Linked Server in sql server 2005?
This is a discussion on What is a Linked Server in sql server 2005? within the Database Support forums, part of the Web Development category; What is a Linked Server in sql server 2005?...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
What is a Linked Server in sql server 2005? |
#2
07-25-2007, 03:39 AM
| |||
| |||
 Re: What is a Linked Server in sql server 2005? Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With a linked server, you can create very clean, easy to follow, SQL statements that allow remote data to be retrieved, joined and combined with local data. Storped Procedure sp_addlinkedserver, sp_addlinkedsrvlogin will be used add new Linked Server.     |
|
#3
08-14-2007, 04:24 AM
| |||
| |||
 Re: What is a Linked Server in sql server 2005? hi..... archer...... kingmaker is right. i will give you the syntax also. I have used the following syntax for loopback linked server. EXEC sp_addlinkedserver @server = N'name_for_linked_server', @srvproduct = N' ', @provider = N'SQLNCLI', @datasrc = N'name_of_my_sqlserver_instance', @catalog = N'name_of_database' Hope this will help you. |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQL Server 2000 migration to SQL Server 2005 Collation Change - Method? | arjkhanna | Database Support | 5 | 10-02-2009 10:58 PM |
| Steps to migrate TFS 2008 from SQL server 2005 to SQL server 2008 | arjkhanna | Server Management | 5 | 04-24-2009 02:17 AM |
| SQL Server 2005 | kingmaker | Database Support | 100 | 03-22-2008 02:08 AM |
| Server Assessment for Sql server 2005? | arjkhanna | Server Management | 3 | 10-30-2007 11:09 AM |
| What’s a “SAND BOX” in SQL Server 2005? | oxygen | Database Support | 1 | 07-26-2007 04:20 AM |
All times are GMT -7. The time now is 10:01 AM.