Forum Replies Created

Viewing 15 posts - 601 through 615 (of 9,715 total)

  • RE: General audit / monitor question

    John Mitchell-245523 - Monday, October 8, 2018 8:30 AM

    Sorry, yes, that's the AuditTable table.  I tried to soften the object names and...

    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 8, 2018 at 8:40 am

    #2008560

  • RE: General audit / monitor question

    Quick question, John. What is this line of code supposed to be referencing?

    SELECT @MostRecentEntryinTable = COALESCE(MAX(EventTime

    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 8, 2018 at 8:25 am

    #2008548

  • RE: General audit / monitor question

    John Mitchell-245523 - Monday, October 8, 2018 6:47 AM

    Just set up a job that imports the data from the audit file every...

    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 8, 2018 at 6:57 am

    #2008527

  • RE: General audit / monitor question

    BAH. SQL Audit (which looks like it could be the right solution) doesn't output to SQL tables. And the people who would be consuming the results of this auditing aren't...

    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 8, 2018 at 6:28 am

    #2008518

  • RE: General audit / monitor question

    Thanks, Guys. I didn't even think of EE or SQL Audit. I'll look at both of those.

    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 8, 2018 at 5:36 am

    #2008511

  • RE: Are the posted questions getting worse?

    Beatrix Kiddo - Monday, October 8, 2018 4:23 AM

    It will be really cold in Iceland in February.

    Isn't it supposed to be frigid...

    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 8, 2018 at 5:35 am

    #2008510

  • RE: Are the posted questions getting worse?

    ZZartin - Friday, October 5, 2018 8:47 AM

    Code should meet requirements, requirements should be properly documented and validation of requirements should...

    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 5, 2018 at 9:02 am

    #2008330

  • RE: Are the posted questions getting worse?

    Jeffery Williams - Friday, October 5, 2018 8:25 AM

    I comment my code, naturally and any developer coming behind me or working...

    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 5, 2018 at 8:44 am

    #2008322

  • RE: Are the posted questions getting worse?

    Thom A - Thursday, October 4, 2018 9:44 AM

    At what point would you suggest that someone is no longer "new to SQL"?...

    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 4, 2018 at 10:39 am

    #2008142

  • RE: SP_Send Mail sends duplicate mail

    Sue_H - Monday, October 1, 2018 11:03 AM

    malakar02amit - Saturday, September 29, 2018 5:15 PM

    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 4, 2018 at 10:36 am

    #2008141

  • RE: Backups and Restoring states

    Sue_H - Tuesday, October 2, 2018 7:12 AM

    SqlGeek89 - Tuesday, October 2, 2018 2:13 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 4, 2018 at 10:34 am

    #2008138

  • RE: Running SSIS Package in scheduled job

    A lot of people are missing a major point here. I don't think SQL Server will run off a file share per say. SQL Server needs to be configured for "File...

    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 4, 2018 at 10:31 am

    #2008135

  • RE: Are the posted questions getting worse?

    Thom A - Thursday, October 4, 2018 9:44 AM

    At what point would you suggest that someone is no longer "new to SQL"?...

    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 4, 2018 at 9:48 am

    #2008114

  • RE: Are the posted questions getting worse?

    Chad Crawford - Thursday, October 4, 2018 7:59 AM

    Now THAT is a short term memory problem.  I thought mine was...

    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 4, 2018 at 8:09 am

    #2008067

  • RE: Are the posted questions getting worse?

    FYI: Totally non-DBA job, but if anyone knows someone looking for a job in Jacksonville... https://careers.allstate.com/job/Jacksonville-Workforce-Management-and-Strategic-Analytics-Flor/509833200/?locale=en_US

    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 3, 2018 at 10:21 am

    #2007894

Viewing 15 posts - 601 through 615 (of 9,715 total)