January 3, 2007 at 10:53 am
Hi,
Just like to ask if there is a way in changing a table's ownership. Ex. from TEMPOWNER to DBO.
Thanks
January 3, 2007 at 12:35 pm
sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'
January 4, 2007 at 10:01 am
Just don't forget to qualify the original object !
sp_changeobjectowner [ @objname = ] 'original_owner.object' , [ @newowner = ] 'owner'
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
January 7, 2007 at 7:55 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply