Forum Replies Created

Viewing 5 posts - 1 through 6 (of 6 total)

  • Reply To: The Random Rows

    I too disagree with the answer, but for another reason:

    Without a table definition, there is no way of knowing that the BusinessEntityID column is a primary key column (not everyone...

    "My gosh! It's full of [SELECT] stars!"

    December 17, 2024 at 9:48 am

    #4499484

  • Reply To: SQLFacts - A Free Toolkit for SQL Server Database Engineers

    (at the time of this reply)

    Gotta love the amount of points the OP/creator has! 🙂

    2021_11_23_13_10_49-Clipboard

    PS: This looks really awesome; will be checking it out soon!

    • This reply was modified 4 years, 6 months ago by dbaninja.

    "My gosh! It's full of [SELECT] stars!"

    November 23, 2021 at 11:12 am

    #3956013

  • Reply To: Exception handling for backup related errors.

    A bit late to the party here, but...

    You can look into implementing Ola Hallengren's maintenance solution (https://ola.hallengren.com/) - it works beautifully.

    • This reply was modified 6 years, 7 months ago by dbaninja. Reason: Incorrect information

    "My gosh! It's full of [SELECT] stars!"

    October 30, 2019 at 10:05 am

    #3693014

  • Reply To: Oops, I deleted that data

    Thanks for the post. I agree with you as I have run into this exact scenario numerous times.

    One caveat though to keep in mind:

    The commented out ROLLBACK / COMMIT sections...

    "My gosh! It's full of [SELECT] stars!"

    October 29, 2019 at 9:07 am

    #3692615

  • RE: Native Audits

    I have successfully used SQL's native auditing features. The only set-back I found was the location for the data (you can only choose "File", Windows "Security Log" or Windows ...

    "My gosh! It's full of [SELECT] stars!"

    May 22, 2015 at 4:07 am

    #1799941

Viewing 5 posts - 1 through 6 (of 6 total)