Issue: If you have another database in the same server, you can write "select * from secondDB.dbo.TableName". But if you want to access another database which is in separate server, then what should we do?
Resolution: I have used "EXEC sp_addlinkedserver with OpenQuery" of SQL Server 2000. I don't know any other better method.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment