• ALZDBA (10/14/2010)


    did you try "sp_changedbowner newlogin, true" ?

    This looks equivalent to what I did through SSMS, but I'm still not sure why the service account was not as good as sa for db ownership.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]