All VCS software is similar and works well for what we tend to do with SQL objects. However for the most part it's a manual process for the check-in/check-out.

If...

Replication.

Replicate out from the Reference db to the other dbs, moving those common objects.

ankitb

We mostly use SCVMM at Red Gate, with the rare Hyper-V console management.

Not sure, have to ask. Not my area 😉

The rest of the trigger is the same. You process the EVENT data. Not every ALTER DATABASE will include a read only option, so you need to parse the event...

I'd think alter database, with a check to see what changed.

All SQLServerCentral servers (dev, test, prod cluster) are virtualized. At Red Gate, we use a ton of Hyper-V stuff in the company, including some critical dbs.

I have friends at a...

LOL, sometimes, but they are also a good way to slip out new features. Facebook,...

Thanks, missed that.

It sooooo depends on what you're doing.

SQL Azure is different than SQL Server. However they offer some better backups/replicas in ways. No idea about pricing. I spoke with a few...

30. Backup is licensed by the server.

For the Virtual Restore side, if you wanted to run this on one server, one license.

Red Gate Sales do negotiate, so if you're interested,...

No hurry. We're 4-6 weeks out on publishing now.

Enterprise Manager should show the status of the database in the tree view. Does it look like all others or is the icon different?

I don't have a 2000 instance handy...

SQLRNNR (5/21/2012)

---

The pizza was not so good - but hey.

I had too much info to cover in 1hr15. I will be trimming it back somewhere. I have some...

Is that database in recovering or restoring mode?