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 2005 Forums
 SQL Server Administration (2005)
 How to access data from different instance of SQL

Author  Topic 

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2009-08-22 : 07:14:56
Hi,

I have two instances of sql server 2005 on my machine,

1. winDB (This is instance name)
2. winDB\db (This is instance name)

These instances have different authorization access,

i want to access the data from one server to another.
any help regarding this will be appreciated.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-08-22 : 12:23:17
Look into Linked Servers.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -