I am trying to delete a database using Enterprise Manager. It seems like
everything works fine, the db is gone from the Databases tree, but when I
try to create a new database with the same name as the one I just deleted, I
get an error stating that the database exists. Also if I try to delete a
login associated to the deleted database, I get the error that it cannot be
deleted because it owns objects in the deleted db. I really don't understand
what's going on here. Could anybody help me out?
Richard
Have you REFRESH the EM after droping db?
"Richard Gjerde" <richard_gjerde@.yahoo.no> wrote in message
news:fdKNd.7739$IW4.168987@.news2.e.nsc.no...
> I am trying to delete a database using Enterprise Manager. It seems like
> everything works fine, the db is gone from the Databases tree, but when I
> try to create a new database with the same name as the one I just deleted,
I
> get an error stating that the database exists. Also if I try to delete a
> login associated to the deleted database, I get the error that it cannot
be
> deleted because it owns objects in the deleted db. I really don't
understand
> what's going on here. Could anybody help me out?
>
|||Well, I just did:-) And the db came up as "suspect". When I dropped it again
it was OK.
So the problem sort of disappeared, but I am still unsure about why it
ocurred in the first place.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23OH5euRDFHA.512@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Richard
> Have you REFRESH the EM after droping db?
>
> "Richard Gjerde" <richard_gjerde@.yahoo.no> wrote in message
> news:fdKNd.7739$IW4.168987@.news2.e.nsc.no...
I[vbcol=seagreen]
deleted,
> I
> be
> understand
>
|||Richard
I prefer using DROP Database by QA not by EM.
"Richard Gjerde" <richard_gjerde@.yahoo.no> wrote in message
news:sEKNd.7744$IW4.168621@.news2.e.nsc.no...
> Well, I just did:-) And the db came up as "suspect". When I dropped it
again[vbcol=seagreen]
> it was OK.
> So the problem sort of disappeared, but I am still unsure about why it
> ocurred in the first place.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23OH5euRDFHA.512@.TK2MSFTNGP15.phx.gbl...
like[vbcol=seagreen]
when[vbcol=seagreen]
> I
> deleted,
a[vbcol=seagreen]
cannot
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment