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?

HowardW (5/21/2012)

---

Restores can't be as fast by definition, as you don't have a backwards path to a point in time restore (Oracle has Flashback, a kind of reverse transaction log),...

SSMS works against Azure databases, so you can use that.

As far as migration, you connect with TDS and then move the data. Red Gate's Data Compare will work, as...

I'm not sure that you can count on the diff to be the size of data change. I suspect that changed extents in there are included, but if anything changes...

No. you're looking for some type of delayed resolution or a scalar replacement at run time, but that's not allowed.

You can't do a

declare @c varchar

select @c = 'Sales'

select * from...