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

Dynamic Connections Expand / Collapse
Posted Tuesday, May 21, 2013 6:46 AM



Group: General Forum Members
Last Login: Today @ 3:41 PM
Points: 7,946, Visits: 19,038
Mordred (5/21/2013)
You'll need a default connection even if you are setting the actual connection with an expression that evaluates at runtime.
Where do I set the default connection? I'm going to start looking now and will post an answer when I find it but if someone posts before I do I'm going to keep checking here.

I think that the poster means the design-time value of the variable which the connection uses - as can be seen in the Variables window.

Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

Just when you think your code is idiot-proof, the world invents a better idiot.
Post #1454973
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse