Ok update.... have tried to use the code snippit of

EXEC sp_MSforeachdb 'USE ?; EXEC sp_changedbowner ''sa'''

and running that on the master database but it errors out with

Msg 15109, Level 16, State 1, Line 1

Cannot change the owner of the master, model, tempdb or distribution database.

Msg 15109, Level 16, State 1, Line 1

Cannot change the owner of the master, model, tempdb or distribution database.

Msg 15109, Level 16, State 1, Line 1

Cannot change the owner of the master, model, tempdb or distribution database.

i have tried on SQL 2008 and 2005 with both returning the same error messages...any ideas? Also this also errors out if its ran on a user database with the same errors.

DHeath