Home Forums SQL Server 2005 Administering determine SQL maintenance plan creator RE: determine SQL maintenance plan creator

  • May 3, 2016 at 11:24 am

    #1876357

    lawson2305 (5/3/2016)

    Well it helps if it is accurate which I'm guessing it is. The two scheduled jobs that exist in the SQL agent job list for these maintenance plans are owned by "SA". So yes you are right no help because it is "SA" but I now know a little more at least.

    Without some kind of auditing turned on it's pretty tough. What you know for sure is it's someone who has permission to do so which is why it's good to lock that down.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001