• I've often had semi stable code with new products being released and the collisions between the production server and demo server weren't worth it.

    Having a decent demo server has always been pretty important and I've usually been able to scrape together enough parts to beef it up. I'd be wary of production just because of the possible problems with reconciling data as well. Keeping demo transactions out of the accounting system gets to be a pain.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones