Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Server Instances Expand / Collapse
Author
Message
Posted Wednesday, July 15, 2009 10:03 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:30 PM
Points: 994, Visits: 1,935
One benefit of instances is that when you create a linked server connection to a database in another instance (of the same machine) then data does not have to travel through a network and the results are typically fast.

----------------------------------------------------
How to post forum questions to get the best help
Post #753635
Posted Wednesday, July 15, 2009 10:07 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 6, 2016 1:53 PM
Points: 2,223, Visits: 3,668
mmartin (7/15/2009)
One benefit of instances is that when you create a linked server connection to a database in another instance (of the same machine) then data does not have to travel through a network and the results are typically fast.


I dont think we need to create linked servers for instances running on same server. or do we? we can access the data using four part notation. [instance Name].database.owner.object





Pradeep Singh
Post #753639
Posted Thursday, July 16, 2009 4:08 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:30 PM
Points: 994, Visits: 1,935
I tried querying using your suggestion on a couple of instances on one of our machines. I was not successful. Maybe I am missing something.

----------------------------------------------------
How to post forum questions to get the best help
Post #754534
Posted Thursday, July 16, 2009 4:16 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:30 PM
Points: 994, Visits: 1,935
My understanding of an instance is that it acts as if it is another server without actually needing to buy another server. Thus I assume all the permissions/checkpoints you normally have in place to access data from another box still apply to instances the reside on the same disk as your reference database.

regards, MMartin


----------------------------------------------------
How to post forum questions to get the best help
Post #754538
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse