Change Table Owner Question
Posted on 2004-08-11
there's a lot of posts about using exec sp_changeobjectowner 'tablename.table', 'dbo' to rename tables back to dbo ownership if they have been created by another owner, but can someone tell me how to specify the database?
Basically we have a live and a dev database - they live is running fine and I don't want to touch it - but want to change the table owner on dev for some tests....
I don't want to run the above command on both - just the dev database...
This is pretty urgent so I've given it max points