• --Also, here's a script for you while I'm at it. 

    DECLARE

     @int_counter INT,

     @int_max INT,

     @txt_name NVARCHAR(255),

     @txt_sql NVARCHAR(2500)

    DECLARE @databases TABLE (

     int_id INT IDENTITY(1,1) PRIMARY KEY,

     txt_name NVARCHAR(255))

    INSERT @databases(txt_name)

     SELECT name FROM master..sysdatabases WHERE name NOT IN ('master','model','tempdb')

    SELECT

     @int_counter = (SELECT MIN(int_id) FROM @databases),

     @int_max = (SELECT MAX(int_id) FROM @databases)

    WHILE @int_counter <= @int_max

    BEGIN

    SELECT @txt_name = (SELECT txt_name FROM @databases WHERE int_id = @int_counter)

    SELECT @txt_sql = '

     USE ' + @txt_name + '

     sp_changedbowner ''sa'''

    --PRINT @txt_sql

    EXEC sp_executesql @txt_sql

    SELECT @int_counter = @int_counter + 1

    END

    --You might want to consider modifying to use sp_MSforeachdb.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.