What you need to do in new query window is right click > Connection > Change Connection, this will change the instance you are connected to.

Brilliant i can work with that

Hi skcadavre,

Thanks for your reply, its not a homework question i'm in the process of designing a SSRS report and i need this section in the store procedure in order...

Thanks for your reply guys

@ninja's_RGR'us I think you might be right on this one just makes it a lot more easier, Do you have any information on...