• Brandie Tarvin (6/20/2013)


    wolfkillj (6/19/2013)


    2) Database ownership? You mean as in who owns MSDB? Well, now that I look at it, the SA account does own MSDB. I wonder if that's the issue.

    Does this make sense to everyone? MSDB being owned by SA would force other accounts to use its credentials when running jobs?

    No. msdb is always owned by the sa account.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]