Ah yes, good spot :hehe:

So the below works fine on 2016, and gives two different hash...

I think the documentation is slightly misleading on this. I've tried the below on SQL 2014 and 2016, and they both give the same result, namely the same hash...

The answer is not quite correct. As written, it will run successfully but will not actually drop the trigger.

For logon triggers you need to use:

DROP TRIGGER IF EXISTS CaptureLogins

ON...

Remember that the INFORMATION_SCHEMA.ROUTINES view also includes any user-defined functions in the database. To just get the list of procs you would need to add a filter:

WHERE ROUTINE_TYPE =...

SELECT SUSER_SNAME(0x01)

Where 0x01 is the SID. This will give you the login name, i.e. at the server level.

I don't think you can add the App Intent to the connection from the Agent job. However, if you change the Readable Secondary option to "Yes" rather than "Read-intent...

This server has been live for about 18 months, but hasn't been restarted for at least...

Thanks Andy, fun bit of trivia for the day!

When searching Google (and I assume Bing) you can use a dash to EXCLUDE certain terms from results, which is why that...

I think I've found the culprit!

We have a database audit running against one of the databases on this server, monitoring access on a single table and writing results to a...

Also, on the VM side, the ESX host has 260GB RAM. The total assigned RAM across all VMs is only 160GB. The performance charts show no ballooning is occurring.

This...

I am aware of this issue but have never experienced it personally. I assume you'd see an instance of...

Kevin,

Build is 11.0.3000 - 2012 SP1.

The VM is our standard built template, fairly standard config. If there are any specific configuration issues that you think might be a problem I...

Agree with previous posters, the page referenced in the explanation has the trace flags the wrong way round. A Connect bug has already been logged about this:

https://connect.microsoft.com/SQLServer/feedback/details/869852/documentation-bug-concerning-new-ce-and-query-trace-flags

Along with most others, I fell into this trap and answered "king_schema". However I do NOT think it's a bad question.

The script doesn't mention anything about the creation of...

george sibbald (2/18/2014)

---

a new database only inherits ALL the properties of model if you use the GUI to create it and take the defaults. Creating a new database via TSQL...