How do I change the owner of a view? I have tried using sp_changeobjectowner which fails because the dependant table is owned by the same user that I'm tring to change the view to. Do I really need to drop and recreate the view? If I attempt to update the uid in sysobjects I get a message claiming there is a duplicate entry.
I'm using SQL Server 2000.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!