Linking a DB in SQL 2000
Posted on 2006-06-13
I am migrating our SQL 2000 databases over to new hardware bceause the old server is dying. I just used the backup/restore feature and moved the "non built in" databases without a hitch.
We have a custom app used on handhelds in our warehouse that uses a SQL backend, which also accesses information from our inventory management software, which runs on an Oracle database.
The old server's master db had a second line in the sysserver table that, from what I can tell, is a link to the oracle database. We're getting errors when we try to connect on some things (run sp_addlinkedserver to add server to sysservers) so I'm wondering what I need to do?
Did I make any sense at all? All I can find from google seaching sp_addlinkedserver is that it appears to be t-sql. Is the only way to accomplish this by using the tsql commands, or is there a way to do it in enterprise manager?