sp_changeobjectowner doesn't work !!!1

[crismartins]

Hello,

I have in my database, an object without owner.
The object in this case is a view, and I have different results:

- When I run the procedure sp_changeobjectowner, I receive the message:
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.

- select name,xtype,uid from sysobjects where name like 'view1'
view1 V 33

- SELECT * FROM INFORMATION_SCHEMA.VIEWS
where table_name = 'view1'

mydata NULL gsis_utilizacao
create view view1 as select nome,sum (consultas) as quantidade from consutasDia NONE NO

- So in my sysusers table I have no uid 33.

What I can do? I can't delete neither change the owner :-(

Thanks a lot

 

[JayKusch]

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

Thanks

J. Kusch