Forum Replies Created

Viewing 15 posts - 526 through 540 (of 9,720 total)

  • RE: General audit / monitor question

    For future readers of this thread, I recommended it to SQLLearner22 on this other thread: https://www.sqlservercentral.com/Forums/2002068/SQL-server-Audit-Trigger-for-INSERT-UPDATE-DELETE

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 16, 2018 at 11:39 am

    #2009930

  • RE: SQL server Audit Trigger for INSERT , UPDATE , DELETE

    SQL learner22 - Tuesday, October 16, 2018 11:17 AM

    Jeff, 
    you are absolute correct on all the points you mentioned about the code...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 16, 2018 at 11:38 am

    #2009928

  • RE: General audit / monitor question

    SQL learner22 - Tuesday, October 16, 2018 11:11 AM

    my understanding on deploying John's Solution.

    Step 1: Create the AuditImport procedure on...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 16, 2018 at 11:34 am

    #2009925

  • RE: Are the posted questions getting worse?

    drew.allen - Tuesday, October 16, 2018 10:00 AM

    Jeff Moden - Tuesday, October 16, 2018 9:02 AM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 16, 2018 at 10:55 am

    #2009917

  • RE: Are the posted questions getting worse?

    jasona.work - Tuesday, October 16, 2018 7:01 AM

    Brandie Tarvin - Tuesday, October 16, 2018 6:03 AM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 16, 2018 at 7:08 am

    #2009855

  • RE: Are the posted questions getting worse?

    jasona.work - Tuesday, October 16, 2018 5:56 AM

    Brandie Tarvin - Tuesday, October 16, 2018 4:01 AM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 16, 2018 at 6:03 am

    #2009844

  • RE: Are the posted questions getting worse?

    Hee. If you had told me 2 years ago that I would be interested in the daily going's on of someone's bowel movements, I'd have told you "You be nuts!"

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 16, 2018 at 6:02 am

    #2009843

  • RE: Are the posted questions getting worse?

    Sigh.

    Why oh why oh why do users not understand their own requirements? I've had to explain this one to the BA 3 times already and they're still trying...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 16, 2018 at 4:38 am

    #2009830

  • RE: SQL server Audit Trigger for INSERT , UPDATE , DELETE

    I am doing a similar thing myself for a database and have discovered the joys of SQL Audit. Now that you've given us some sample code, I'm willing to share...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 16, 2018 at 4:05 am

    #2009824

  • RE: Are the posted questions getting worse?

    OMG. Is it snowing in Florida? Is that ice I see on the roads?

    I think I might actually LIKE a post from Mr. ANSI-Standards-Override-All!

    <thump>

    Someone,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 16, 2018 at 4:01 am

    #2009823

  • RE: What's wrong with my table?

    Jeff Moden - Monday, October 15, 2018 12:19 PM

    It's official, folks.  The man is NOT an idiot.  Rather, he's quite clever, as I...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 12:20 pm

    #2009692

  • RE: Query slow. Help improve?

    SQLStud 74876 - Monday, October 15, 2018 12:04 PM

    Jeff Moden - Saturday, October 13, 2018 10:25 AM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 12:19 pm

    #2009691

  • RE: Are the posted questions getting worse?

    Thom A - Monday, October 15, 2018 12:04 PM

    Brandie Tarvin - Monday, October 15, 2018 11:07 AM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 12:12 pm

    #2009687

  • RE: What's wrong with my table?

    SQLStud 74876 - Monday, October 15, 2018 11:53 AM

    Ahhh man!  You guys are a tough crowd!

    We are trying to help. If you...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 12:10 pm

    #2009686

  • RE: Are the posted questions getting worse?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 11:40 am

    #2009677

Viewing 15 posts - 526 through 540 (of 9,720 total)