https://technet.microsoft.com/en-us/library/bb677622(v=sql.110).aspx

https://technet.microsoft.com/en-us/library/bb677622(v=sql.120).aspx

Looks ok to me, not a case of missing [] around msRTCSIP-PrimaryUserAddress in the OPENQUERY is it?

You could but as the people have sysadmin rights they could just disable the trigger then remove the object.

As Gail stated, you can't stop people with sysadmin doing anything, you...

Not without seeing the full query, but sounds like you have a syntax error near - on line 19

As with anything licensing, you should speak to Microsoft directly or your Microsoft reseller, and always ensure you get the final in email to cover your backs, as licensing is...

IIRC, it applies to all databases

Edit, yep MSDN details 1118 is a global traceflag so applies to all DB's

Mail admins eh? Can't live with them and can't live without them.

Grant Fritchey (11/19/2015)

GilaMonster (11/19/2015)

Phil Parkin (11/19/2015)

The caveat to this is that if someone created the DB and specified upon creation that the file extensions should be .sql instead of mdf/ndf/ldf...

.sql is the extension of a script file not a database, its not an mdf/ndf/ldf file and thus cannot be attached or detached from SQL.

The caveat to this is that...

The problem I find with the sequence in this case is there will be a hell of a lot of sequences and the need for dynamic sql to build up...

Mark

Maximum length data types are not indexable

Index key length maximum is 900 bytes.

Int is 4 bytes, that leaves 896 bytes, so you will need to change your varchar(max) to varchar(896)...

I'd say you would need another 5 disks

One for the instance binaries,

One for TempDB

One for User Data

One for User Logs

One for Backups

Wouldn't advise putting all of them on one drive,...

SQL 2014 is supported on Server 2008R2 SP1 or above, so aslong as the cluster is running atleast OS service pack 1 you will be fine to install it.

However, does...

SQL sent the mail successfully to your SMTP server.

Speak with your mail admins again to see if the old SMTP server is still alive. It may just have its...