You could set a synonym in each database that points to the appropriate environment and then make that the same in each database. Then use the synonym in your script.

Replication doesn't work with IIS. It works with other databases.

Usually a web application has a database. That database would be the subscriber.

jay-h (6/15/2012)

---

No. It is not a zero sum game, wealth comes from productivity and circulation, neither of which are inhibited by certain people acquiring pockets of wealth. What do you...

bwillsie-842793 (6/15/2012)

---

Guess who can't get jobs now that they have their "Poli Sci" degrees.

Personally, I am convinced we place far too much enphasis on "get a college degree" and not...

IceDread (6/15/2012)

---

First of all, I think a lot of jobs are being moved to countries where it cost less in several ways with employees because of salary, less health insurances...

The typo has been corrected and points awarded back.

My apologies for the typo.

I heard from a few people about flaws in the exams, and I noticed a few. I suspect that there were issues, but I'm not sure there were a ton....

Wow, I passed it as well.

Crazy. I was sure I'd blown one of them. I suspect the poor proofing on the tests allowed a few of us to squeak through.

So...

Your vote is needed.

I agree that registration is a pain, but it's also part of the "cost" of many sites.

If you think passwords are a pain, then you're doing it...

phonetictalk (6/14/2012)

---

ACinKC (6/14/2012)

---

Not to take this in a different direction, but that is a misquote of Lincoln. The correct quote (which still carries the same message: Plan a whole...

ACinKC (6/14/2012)

---

Not to take this in a different direction, but that is a misquote of Lincoln. The correct quote (which still carries the same message: Plan a whole lot...

Markus (6/14/2012)

---

I believe this is ONLY the 22nd Perfect game in the history of MLB. So, if you look at it that way with 30 teams right now quite a...

You're confused.

There is no output of the job here. You get logging from the job, or you get the output from a stored proc, but don't conflate the idea...

djackson 22568 (6/14/2012)

---

Personally my preference is jump right in and start coding a bit to prove the concept, then stop and refine the design, then do the actual coding. ...

Stefan Krzywicki (6/14/2012)

---

I've heard good things about cloudshare[/url]. It is an inexpensive, flexible dev environment. You can pick and choose what you get and end up with a more powerful,...