With Rainbow installations, occasionally I'll end up with some (or all) objects in the database being owned by my local ASPNET account (computername\ASPNET).  This results from building the database with a trustedconnection, and while I know this, I always forget and do it anyway. 

The problem is that when I try to upload the existing database to a 'live' one somewhere, now that local ASPNET account owns everything and things go very sideways. 

Anyway, I found this SQL script a while ago that (in two steps) changes the ownership of all the objects in a database to 'dbo'.  I didn't write it, and it's been so long now, I don't even know where I got it...if it was yours, thank you very much.  If not, here it is:

SELECT 'EXEC(''sp_changeobjectowner @objname = '''''+   ltrim(u.name) + '.' + ltrim(s.name) + ''''''   + ', @newowner = dbo'')'
FROM  sysobjects s,       sysusers u
WHERE s.uid = u.uid
AND   u.name <> 'dbo'
AND   xtype in ('V', 'P', 'U')
AND   u.name not like 'INFORMATION%'
order by s.name

Run this in Query Analyzer (with 'Results to Text' option set), then copy those results into a new QA window and run them.