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: Yesterday @ 8:04 PM
Points: 7,441, Visits: 18,030
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.

Never attribute to malice that which is adequately explained by stupidity
Post #1454973
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse