Excellent knowledge-sharing! Thanks for taking the time to help.

In theory that sounds fine, in practice not so much:

Say I have Bull1 associated with Cust1, Cust2, Cust3, Cust4, Cust5. User now opens a UI screen with cust_checkboxes checked...

Not only is SS2000 popular, but I have a feeling there are many companies in the same boat we are: we'll never have enough staff to have time to migrate...

Excellent post, really answered things. And thanks DCarlson too...good conversation. I suspected that separate dbs per version (on stage) was the way to go. But before we...

Dcarlson (12/10/2008)

---

We use a three stage system. We will have a development database, a staging database, and a production database. The development database is where all, shall we say, uh,...

Dcarlson (12/10/2008)

---

Steve Jones - Editor (12/10/2008)

---

I think the nomenclature here is confusing people.

The database is the schema+data+physical files. You wouldn't put this into VCS. You would put in the scripts...

What do you do with different releases then? For ex, TFS/DEV/Release1, TFS/DEV/Release2 etc....

Does your source control merge the changes into the physical SPROC or just into the scripts that can generate the physical SPROC? My initial issue was really one about...

I mean versions of the Db. On my test server (and dev server too) where we do user testing we've always had a single db named ABC. Inside...

"In a branch" means a branch inside the source control system that's holding...

So what do you do when versions of, for ex a SPROC, conflict? Let's say V1 of your app is in production. V2 is in user testing. Now a bug...

Thanks. And what about the physical tables, sprocs, etc. Do you typically keep completely different physical db's for each version of the app you're supporting, like what's done...

Good info. Is there any reason to specifically not include the directive for MARS in a connection string? Does it hurt existing code, even if it doesn't benefit...

I think you're out of luck. I was disappointed when I saw that all MS provides for entering a SQL Statement is the squirrelly text box. It would be...