I tried to drop a table in Enterprise Manager but it won't allow me and it's
just a user table. How else can I drop it? Thanks.Can you give us the error message?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00kobebrian" <abc@.yahoo.com> wrote in message news:%23r0w1vonGHA.764@.TK2MSFTNGP03.phx.gbl..
.
>I tried to drop a table in Enterprise Manager but it won't allow me and it'
s just a user table. How
>else can I drop it? Thanks.
>
>|||I hate to be the guy who asks this, but do make sure that you refresh
the treeview on the left after you drop. This happened to me once and I
was stumped for a long time. Finally, I closed enterprise manager and
restarted. Then I realized that the table dropped, but it wasn't being
reflected in the view.
Tibor Karaszi wrote:[vbcol=seagreen]
> Can you give us the error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "00kobebrian" <abc@.yahoo.com> wrote in message news:%23r0w1vonGHA.764@.TK2M
SFTNGP03.phx.gbl...|||"Rich" <rich@.adgooroo.com> wrote in message
news:1151941402.034081.206570@.j8g2000cwa.googlegroups.com...
> I hate to be the guy who asks this, but do make sure that you refresh
> the treeview on the left after you drop. This happened to me once and I
> was stumped for a long time. Finally, I closed enterprise manager and
> restarted. Then I realized that the table dropped, but it wasn't being
> reflected in the view.
BTW, you wouldn't be the first person to do this. :-)
>
> Tibor Karaszi wrote:
news:%23r0w1vonGHA.764@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
it's just a user table. How[vbcol=seagreen]
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment