Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akpaga
Constraint Violating Yak Guru
331 Posts |
 Posted - 2008-10-28 : 11:53:01
|
| hi i have an instance on Sql server 2000 on my local machine .I have new database server(sql server 2005) on a remote location.How can i create a database link to the database on that server so that i can access the tables of that databse from my local machine .Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-28 : 11:56:24
|
| use sp_addlinkedserver system stored procedurehttp://doc.ddart.net/mssql/sql70/sp_adda_17.htm |
 |
|
|
akpaga
Constraint Violating Yak Guru
331 Posts |
Posted - 2008-10-28 : 12:28:15
|
| can you be more specific,please ?coz i want to use something like thisremoteserver.mydatabse.dbo.tablename.Is that possible when accessing tables using query analyzer. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-28 : 12:38:51
|
| its possible but before that you need to add the remote server as linked server using sp_addlinkedserver.Did you have a look at link posted. it contains some examples. |
|
|
|
|
|
|
create database link