怎样删除丢失owner的view或恢复view的owner?

Question

在SQL 2000中自行定义了view，当定义view的用户删除后，view就丢失了owner。请问：怎样删除这个丢失owner的view 或赋予这个view新的owner? 谢谢！

Answer 1

Use sp_changeobjectowner to assign new owner.

Answer 2

执行后显示： Object 'badview' does not exist or is not a valid object for this operation

说明系统找不到那个'badview'，请问能否删除这个丢失owner的view？ 用drop view不行。谢谢！

Answer 3

badview 前有加上 owner名称么？

Answer 4

这个'baoudview'没有owner, 丢失了。

Answer 5

Did you see it in sysobjects table? Can you post that row?