July 24, 2002 at 2:14 pm
Hi,
I have several sub-departments that use DTS to transfer objects into a central repository with their own credentials. These users are Owners of their own databases. However, after they transfer the objects, on the central repository, ,the owner is no longer DBO, but is the user who went through the wizard to set up the DTS. That prevents me from work I need to do.
Is there a way arround that? (other than myself going there and logging as SA)
Thanks
A
July 24, 2002 at 3:49 pm
sp_changeobject_owner can reset them.
Steve Jones
July 25, 2002 at 10:02 am
I've got that, but i was hopping there was a way to keep the dbo ownership while sending. This is an everyday event.
A.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply