I keep waiting to see Joe C show up in the "Give Up on Natural Primary Keys" topic...
It'd be interesting to see what his take on it is, especially...

How could it, the...

I know I've made similar comments before, but it's almost amazing how good it feels to accomplish something as simple as creating a SSIS package to check if a table...

The certificate used for encrypting connections isn't stored in SQL Server, but in the OS.  If you want to check the certificate, you need to go to SQL Configuration Manager...

You're asking SQL to do something it's not designed to do, behave like a "real" e-mail client (Outlook, Thunderbird, etc.)
With the addresses you've given as examples, the first one,...

Northern Soul is correct, Enterprise does allow databases larger than 10GB (actually 524PB, I looked recently.)

But, first you should also look into whether you even need to go...

My last round of deployments, I set up a command line install script.  Tweaked the locations for the databases, logs, etc, set the service accounts and the first SA account,...

You're trying to restore a backup from a higher version of SQL Server (2008R2 / 10.50.XXXX) to a lower version of SQL Server (2008 / 10.0.XXXX) which can not be...