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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Linked Servers

Author  Topic 

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2011-04-09 : 03:57:16
Is there is a SQL statement to add a new Linked Server (SQL Server)?
Thanks in advanced.




For fast result follow this...
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

Want Philippines to become 1st World COuntry? Go for World War 3...

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-04-09 : 09:48:06
I have not done it in SQL 2000, but seems like it is the same sp_addlinkedserver. See documentation and examples here: http://msdn.microsoft.com/en-us/library/aa936675(v=sql.80).aspx
Go to Top of Page

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2011-04-10 : 02:39:14
geeee tnx a lot. ^^

For fast result follow this...
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

Want Philippines to become 1st World COuntry? Go for World War 3...
Go to Top of Page
   

- Advertisement -