Forum Replies Created

Viewing 15 posts - 1 through 15 (of 30 total)

  • Reply To: Simple SSIS package that is successful, but "fails"

    After much digging and looking at performance, we found the cause to be high I/O. We used SQL Sentry, DMVs, and logs to determine that it might have been caused...


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    July 9, 2024 at 5:31 pm

    #4434608

  • RE: Laptop Cooling Device with Docking Station

    Jeff Moden - Thursday, February 7, 2019 8:08 AM

    Sean Perkins - Monday, February 4, 2019 7:32 AM


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    February 7, 2019 at 8:30 am

    #2021400

  • RE: Connection Manager in SSIS 2017 Package NOT Saving the Password

    Joe Torre - Thursday, August 30, 2018 4:08 PM

    You make the login and password parameters and set them in the job.

    Thank you...


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    September 4, 2018 at 1:53 pm

    #2004433

  • RE: SQLServerAgent Error: The process cannot access the file because it is being used by another process

    Sue_H - Wednesday, November 29, 2017 12:07 PM

    Sean Perkins - Wednesday, November 29, 2017 8:22 AM


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    November 29, 2017 at 12:25 pm

    #1969966

  • RE: SQLServerAgent Error: The process cannot access the file because it is being used by another process

    @Sue_H - there were no jobs running at the same time the job is scheduled to run, nor during my tests in the middle of the day.

    @goher2000 -...


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    November 29, 2017 at 8:22 am

    #1969924

  • RE: Log Shipping and Ola's Hallengren's Scripts - Can they work in unison?

    Yeah, I just saw that after using Control+F "shipping" and found that answer.  I was perusing his FAQ yesterday late in the day after staring at TSQL code all day,...


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    April 12, 2017 at 8:43 am

    #1937862

  • RE: How Do I Find Who Last Edited a Record or Table in a Database?

    Eric M Russell - Wednesday, April 5, 2017 12:11 PM

    Sean Perkins - Wednesday, April 5, 2017 11:48...


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    April 5, 2017 at 2:51 pm

    #1936918

  • RE: How Do I Find Who Last Edited a Record or Table in a Database?

    Well, I think I think I might have found what I'm looking for.

    It turns out that I can run PowerShell code against the site collections and it'll give...


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    April 5, 2017 at 11:48 am

    #1936879

  • RE: Management Studio freezing after writing a few lines of code

    bmg002 - Tuesday, April 4, 2017 9:55 AM

    Are others experiencing similar issues?
    Is your version of SSMS compatible with your version of Apex?
    Is...


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    April 5, 2017 at 7:16 am

    #1936775

  • RE: How Do I Find Who Last Edited a Record or Table in a Database?

    Eric M Russell - Tuesday, April 4, 2017 7:55 AM

    What process is involved in editing a row; is that a stored procedure...


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    April 4, 2017 at 3:28 pm

    #1936655

  • RE: How Do I Find Who Last Edited a Record or Table in a Database?

    ScottPletcher - Monday, April 3, 2017 4:18 PM

    SQL doesn't provide that info by default.  You would need your own code already in...


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    April 4, 2017 at 7:17 am

    #1936519

  • RE: How to fix an odd LSBackup job error in Log Shipping?

    Sue_H - Friday, March 17, 2017 10:36 AM

    Sean Perkins - Friday, March 17, 2017 9:13 AM


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    March 20, 2017 at 10:09 am

    #1934031

  • RE: CHECKDB - Cannot continue the execution because the session is in the kill state.

    I'm receiving this error message and I don't have a space issue.

    Are there any other suggestions to check out?


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    October 21, 2016 at 12:34 pm

    #1908073

  • RE: SQL Login keeps losing access to databases

    Sean now understands!

    I thank you and greatly appreciate both of you for taking the time to help me and explain how this works.

    I assure you this is a lesson that...


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    August 30, 2016 at 7:59 am

    #1898314

  • RE: SQL Login keeps losing access to databases

    Lynn Pettis (8/29/2016)

    First, to clarify, you say this only happens on the mirrored instances of SQL Server, not the stand alone instances.

    When you get these errors, has there been a...


    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.

    August 29, 2016 at 5:55 pm

    #1898195

Viewing 15 posts - 1 through 15 (of 30 total)