Create View already in Database

[bdragoo]

We've been trying to plant a Create View into our server, but whenever we attempt to execute the script, we get an error message that says "Cannot create ViewXYZ because there is already object ViewXYZ in database".

Naturally, there are no tables, views, or other readily apparent objects called ViewXYZ. We have rebooted, checked and re-checked, ran patches, etc.

Now we're stumpted, and I turn to the knowledge of the boards for assistance!

 

[PHV]

Have you enough permissions to create a view ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mrdenny]

There's got to be something with that name in the database. Check the sysobjects table.

select *
from sysobjects
where name = 'ViewXYZ'

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[bdragoo]

PHV-

I have administrator rights, so that definately is not an issue. Has anyone encountered this problem before, perhaps?

 

[bdragoo]

btw, MrDenny, I was able to track down a rogue table using your method. Thanks for the tip!

 

[mrdenny]

no prob.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)