SMTP is the protocol for sending mail.

SNMP is a network management protocol.

Database Mail will send across SMTP.

You can integrate VCS with SQL Compare (also from Red Gate) to build a set of change scripts from source control.

Gianluca Sartori (5/22/2012)

---

I wonder why earthquakes always happen at night here. It's the worst time of the day, when everyone is sleeping and it takes some time to realize what's...

I tend to be with Sean. I'd do this:

Table1

ID INT

more columns

Table2

ID INT

FKID INT

where I'd name the FKID something that makes sense.

Or more formally:

Create table Customers (

CustomerID int

, CustomerName...

Just an FYI, I tend to use semi-colons separately. Just for ease of editing and working.

alter database MyDb set read_only

;

go

select name

from sys.databases

where name not in ('master', 'msdb')

;

That way...

OK, some more details. Apparently we have everything:

VM Workstation

vCloud director

Lab Manager

SCVMM 2008

ESXi HyperVisors

OpenSack

Physical Machines - we have some of these.

The tools above are used in different areas for...

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.