Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Trigger Happy

    Ah, sorry, I missed the WITH EXECUTE AS 'Auditor' which is a fix to my version of the trigger (which is very close to the one exposed here).

    The script...

  • RE: Trigger Happy

    Hello!

    Thank you for the article, that DDL trigger have made my boss (and me) happy auditing "who did what to the production systems" (or even the dev ones) for a...

  • RE: Why Log Shipping is still a viable solution in 2016

    jfogel, in fact my custom scripts were originally meant to help me restore the databases to a point in time quickly, reading the databases backup history data, copied over from...

  • RE: Why Log Shipping is still a viable solution in 2016

    Thank you! I thought I had read this one through but I must have got lost somewhere 😛

    Ah, I can see there are indeed restrictions... page 18-19:

    License Mobility is a...

  • RE: Why Log Shipping is still a viable solution in 2016

    Nice article, Kevin, thank you.

    I have developed a custom log shipping solution for our DR server (more flexible than the Microsoft one, and without agent jobs all over the place)....

  • RE: OPTION (FAST x) and trace flag 8722

    Paul White himself replied to my question on StackOverflow/StackExchange. The gist of it: that trace flag isn't really supported anymore apparently, so the initial code should be fixed.

    Here is the...

  • RE: OPTION (FAST x) and trace flag 8722

    Oh, I will for sure... but for the time being, it looks like I'll have to make a support call to Microsoft 😉

Viewing 7 posts - 1 through 7 (of 7 total)