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
 Transact-SQL (2005)
 Access a different instances on the Same Server

Author  Topic 

janets20
Starting Member

12 Posts

Posted - 2011-05-23 : 23:17:25
Hi,

I am writing a new Stored Procedure which needs to access 4 instances on the same server. How to go about it.


Cheers
Janet

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2011-05-24 : 14:32:35
One option is to use Linked Servers.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-05-27 : 00:49:52
u can go to central mangement server option .. i hope
Go to Top of Page
   

- Advertisement -