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 @ 2:25 AM
Points: 7,547, Visits: 18,284
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.

The Dunning-Kruger Effect: the metacognitive inability of those of low ability to recognize their ineptitude and evaluate their ability accurately.
Post #1454973
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse