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.