Error removing a view

Error removing a view

Post by SmVyYmVhcj » Fri, 09 Jul 2004 01:54:01


I have developer who created a view on a database in SQL MSDE 2000 and for some reason it was created without an owner. When I try to DROP this view I get the following error message:
Cannot drop the view 'V_RATE_CATEGORY', because it does not exist in the system catalog.

Any help on how I can get this view would dropped would be greatly appreciated

Thanks,

Jerry
 
 
 

Error removing a view

Post by Andrea Mon » Fri, 09 Jul 2004 02:21:30

hi,
"Jerbear64" < XXXX@XXXXX.COM > ha scritto nel messaggio

I get
system
appreciated

it's actually not possible the object not having an owner... it will inherit
the creator owner name...
if you logged in with a different login that not maps to that user, try
locating it with it's owner name in the form , owner_name.object_name
if his user name in the database is minnie, try
minnie.V_RATE_CATEGORY
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.yqcomputer.com/ ://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

 
 
 

Error removing a view

Post by Jerbear6 » Fri, 09 Jul 2004 02:37:22

Modify the table sysobjects field UID and change it from a
11 to 1 and then I was able to remove the view.

Jerry


MSDE 2000 and for some reason it was created without an
owner. When I try to DROP this view I get the following
error message:
not exist in the system catalog.
be greatly appreciated
 
 
 

Error removing a view

Post by Russell Fi » Fri, 09 Jul 2004 05:28:20

Jerry,

A similar question was just raised in the .server group. Do you know what
tool the developer was using? (I have only seen this when developing using
Access 2000 ADPs. But that may not be the only cause. That is why I am
curious.)

Russell Fields