Object without owner?!?!

Hello people,
anyone has this problem? I'm seeing an object without owner in my
database. So I cannot delete it or alter it. Anyone knows
- how can reproduce this situation ?
- how can it happen?
- how can I detour it?
The uid in sysobjects for this view is 33, but in sysusers I have no
this uid.
I tried to use the stored procedure sp_changeobjectowner, but I receive
the following error:
sp_changeobjectowner 'view1', 'dbo'
go
Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner,
Line 38
Object 'view1' does not exist or is not a valid object for
this operation.
Any ideas will be apreciated!!!
Thanks a lot,
Cris
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Hi
This looks as if you may have restored the database from a backup taken on a
different machine or attached them from a different server?
In which case you probably have orphaned users. If you have not transferred
the user you will need to and then resolve the orphans
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#4
John
"Cristiana Martins" <anonymous@.devdex.com> wrote in message
news:Ox1tAc1PDHA.1908@.TK2MSFTNGP11.phx.gbl...
> Hello people,
> anyone has this problem? I'm seeing an object without owner in my
> database. So I cannot delete it or alter it. Anyone knows
> - how can reproduce this situation ?
> - how can it happen?
> - how can I detour it?
> The uid in sysobjects for this view is 33, but in sysusers I have no
> this uid.
> I tried to use the stored procedure sp_changeobjectowner, but I receive
> the following error:
> sp_changeobjectowner 'view1', 'dbo'
> go
> Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner,
> Line 38
> Object 'view1' does not exist or is not a valid object for
> this operation.
> Any ideas will be apreciated!!!
> Thanks a lot,
> Cris
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!