Drop table causes system to hang

I have a table in SQL 2000 that I cannot drop with either Enterprise Manager
or Query Analyzer (drop table tblName). I don't get an error message, I just
get the hour glass. I got the data out of it - I could ignore it, but I'd
rather get rid of it. I created it with a create table statement, if that
makes any difference.
It must be being used by some process somehow.
You may set its access to Restrict Access: Members of... from the
database's properties and then try dropping it again?
Or detach that database and delete its "mdf" (ndf) and "ldf" files.
Ekrem ?nsoy
"mlwallin" <mlwallin@.discussions.microsoft.com> wrote in message
news:4D3ED88B-5A01-49F5-9210-DE1572BE0DE7@.microsoft.com...
>I have a table in SQL 2000 that I cannot drop with either Enterprise
>Manager
> or Query Analyzer (drop table tblName). I don't get an error message, I
> just
> get the hour glass. I got the data out of it - I could ignore it, but I'd
> rather get rid of it. I created it with a create table statement, if that
> makes any difference.
|||Hi Ekrem,
How detaching and deleting mdf and ldf files can help to drop a table?
Thanks,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Ekrem ?nsoy" wrote:

> It must be being used by some process somehow.
> You may set its access to Restrict Access: Members of... from the
> database's properties and then try dropping it again?
> Or detach that database and delete its "mdf" (ndf) and "ldf" files.
> --
> Ekrem ?nsoy
>
> "mlwallin" <mlwallin@.discussions.microsoft.com> wrote in message
> news:4D3ED88B-5A01-49F5-9210-DE1572BE0DE7@.microsoft.com...
>
|||I guess I was kinda drunk while typing that =) I probably assumed he wanted
to delete the database itself.
However it could work in terms of disconnecting processes which use the
mentioned table.
Ekrem ?nsoy
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:EC2F8E1B-A7C0-4147-BEE9-D81CAA9BCC8D@.microsoft.com...[vbcol=seagreen]
> Hi Ekrem,
> How detaching and deleting mdf and ldf files can help to drop a table?
> Thanks,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Ekrem ?nsoy" wrote:
|||How about some constructive advice?
"Ekrem ?nsoy" wrote:

> I guess I was kinda drunk while typing that =) I probably assumed he wanted
> to delete the database itself.
> However it could work in terms of disconnecting processes which use the
> mentioned table.
> --
> Ekrem ?nsoy
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:EC2F8E1B-A7C0-4147-BEE9-D81CAA9BCC8D@.microsoft.com...
>

Drop table causes system to hang

I have a table in SQL 2000 that I cannot drop with either Enterprise Manager
or Query Analyzer (drop table tblName). I don't get an error message, I just
get the hour glass. I got the data out of it - I could ignore it, but I'd
rather get rid of it. I created it with a create table statement, if that
makes any difference.It must be being used by some process somehow.
You may set its access to Restrict Access: Members of... from the
database's properties and then try dropping it again?
Or detach that database and delete its "mdf" (ndf) and "ldf" files.
--
Ekrem Ã?nsoy
"mlwallin" <mlwallin@.discussions.microsoft.com> wrote in message
news:4D3ED88B-5A01-49F5-9210-DE1572BE0DE7@.microsoft.com...
>I have a table in SQL 2000 that I cannot drop with either Enterprise
>Manager
> or Query Analyzer (drop table tblName). I don't get an error message, I
> just
> get the hour glass. I got the data out of it - I could ignore it, but I'd
> rather get rid of it. I created it with a create table statement, if that
> makes any difference.|||Hi Ekrem,
How detaching and deleting mdf and ldf files can help to drop a table?
Thanks,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Ekrem Ã?nsoy" wrote:
> It must be being used by some process somehow.
> You may set its access to Restrict Access: Members of... from the
> database's properties and then try dropping it again?
> Or detach that database and delete its "mdf" (ndf) and "ldf" files.
> --
> Ekrem Ã?nsoy
>
> "mlwallin" <mlwallin@.discussions.microsoft.com> wrote in message
> news:4D3ED88B-5A01-49F5-9210-DE1572BE0DE7@.microsoft.com...
> >I have a table in SQL 2000 that I cannot drop with either Enterprise
> >Manager
> > or Query Analyzer (drop table tblName). I don't get an error message, I
> > just
> > get the hour glass. I got the data out of it - I could ignore it, but I'd
> > rather get rid of it. I created it with a create table statement, if that
> > makes any difference.
>|||I guess I was kinda drunk while typing that =) I probably assumed he wanted
to delete the database itself.
However it could work in terms of disconnecting processes which use the
mentioned table.
--
Ekrem Ã?nsoy
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:EC2F8E1B-A7C0-4147-BEE9-D81CAA9BCC8D@.microsoft.com...
> Hi Ekrem,
> How detaching and deleting mdf and ldf files can help to drop a table?
> Thanks,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Ekrem Ã?nsoy" wrote:
>> It must be being used by some process somehow.
>> You may set its access to Restrict Access: Members of... from the
>> database's properties and then try dropping it again?
>> Or detach that database and delete its "mdf" (ndf) and "ldf" files.
>> --
>> Ekrem Ã?nsoy
>>
>> "mlwallin" <mlwallin@.discussions.microsoft.com> wrote in message
>> news:4D3ED88B-5A01-49F5-9210-DE1572BE0DE7@.microsoft.com...
>> >I have a table in SQL 2000 that I cannot drop with either Enterprise
>> >Manager
>> > or Query Analyzer (drop table tblName). I don't get an error message,
>> > I
>> > just
>> > get the hour glass. I got the data out of it - I could ignore it, but
>> > I'd
>> > rather get rid of it. I created it with a create table statement, if
>> > that
>> > makes any difference.|||How about some constructive advice?
"Ekrem Ã?nsoy" wrote:
> I guess I was kinda drunk while typing that =) I probably assumed he wanted
> to delete the database itself.
> However it could work in terms of disconnecting processes which use the
> mentioned table.
> --
> Ekrem Ã?nsoy
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:EC2F8E1B-A7C0-4147-BEE9-D81CAA9BCC8D@.microsoft.com...
> >
> > Hi Ekrem,
> >
> > How detaching and deleting mdf and ldf files can help to drop a table?
> >
> > Thanks,
> >
> > Ben Nevarez
> > Senior Database Administrator
> > AIG SunAmerica
> >
> >
> >
> > "Ekrem Ã?nsoy" wrote:
> >
> >> It must be being used by some process somehow.
> >>
> >> You may set its access to Restrict Access: Members of... from the
> >> database's properties and then try dropping it again?
> >>
> >> Or detach that database and delete its "mdf" (ndf) and "ldf" files.
> >>
> >> --
> >> Ekrem Ã?nsoy
> >>
> >>
> >>
> >> "mlwallin" <mlwallin@.discussions.microsoft.com> wrote in message
> >> news:4D3ED88B-5A01-49F5-9210-DE1572BE0DE7@.microsoft.com...
> >> >I have a table in SQL 2000 that I cannot drop with either Enterprise
> >> >Manager
> >> > or Query Analyzer (drop table tblName). I don't get an error message,
> >> > I
> >> > just
> >> > get the hour glass. I got the data out of it - I could ignore it, but
> >> > I'd
> >> > rather get rid of it. I created it with a create table statement, if
> >> > that
> >> > makes any difference.
> >>
>|||I'd check for blocking (sp_who, sp_who2, sp_lock etc).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mlwallin" <mlwallin@.discussions.microsoft.com> wrote in message
news:5704E6AD-6BEE-421A-98BD-2F8BD177ABB0@.microsoft.com...
> How about some constructive advice?
>
> "Ekrem Ã?nsoy" wrote:
>> I guess I was kinda drunk while typing that =) I probably assumed he wanted
>> to delete the database itself.
>> However it could work in terms of disconnecting processes which use the
>> mentioned table.
>> --
>> Ekrem Ã?nsoy
>>
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:EC2F8E1B-A7C0-4147-BEE9-D81CAA9BCC8D@.microsoft.com...
>> >
>> > Hi Ekrem,
>> >
>> > How detaching and deleting mdf and ldf files can help to drop a table?
>> >
>> > Thanks,
>> >
>> > Ben Nevarez
>> > Senior Database Administrator
>> > AIG SunAmerica
>> >
>> >
>> >
>> > "Ekrem Ã?nsoy" wrote:
>> >
>> >> It must be being used by some process somehow.
>> >>
>> >> You may set its access to Restrict Access: Members of... from the
>> >> database's properties and then try dropping it again?
>> >>
>> >> Or detach that database and delete its "mdf" (ndf) and "ldf" files.
>> >>
>> >> --
>> >> Ekrem Ã?nsoy
>> >>
>> >>
>> >>
>> >> "mlwallin" <mlwallin@.discussions.microsoft.com> wrote in message
>> >> news:4D3ED88B-5A01-49F5-9210-DE1572BE0DE7@.microsoft.com...
>> >> >I have a table in SQL 2000 that I cannot drop with either Enterprise
>> >> >Manager
>> >> > or Query Analyzer (drop table tblName). I don't get an error message,
>> >> > I
>> >> > just
>> >> > get the hour glass. I got the data out of it - I could ignore it, but
>> >> > I'd
>> >> > rather get rid of it. I created it with a create table statement, if
>> >> > that
>> >> > makes any difference.
>> >>

Drop table causes system to hang

I have a table in SQL 2000 that I cannot drop with either Enterprise Manager
or Query Analyzer (drop table tblName). I don't get an error message, I jus
t
get the hour glass. I got the data out of it - I could ignore it, but I'd
rather get rid of it. I created it with a create table statement, if that
makes any difference.It must be being used by some process somehow.
You may set its access to Restrict Access: Members of... from the
database's properties and then try dropping it again?
Or detach that database and delete its "mdf" (ndf) and "ldf" files.
Ekrem ?nsoy
"mlwallin" <mlwallin@.discussions.microsoft.com> wrote in message
news:4D3ED88B-5A01-49F5-9210-DE1572BE0DE7@.microsoft.com...
>I have a table in SQL 2000 that I cannot drop with either Enterprise
>Manager
> or Query Analyzer (drop table tblName). I don't get an error message, I
> just
> get the hour glass. I got the data out of it - I could ignore it, but I'd
> rather get rid of it. I created it with a create table statement, if that
> makes any difference.|||Hi Ekrem,
How detaching and deleting mdf and ldf files can help to drop a table?
Thanks,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Ekrem ?nsoy" wrote:

> It must be being used by some process somehow.
> You may set its access to Restrict Access: Members of... from the
> database's properties and then try dropping it again?
> Or detach that database and delete its "mdf" (ndf) and "ldf" files.
> --
> Ekrem ?nsoy
>
> "mlwallin" <mlwallin@.discussions.microsoft.com> wrote in message
> news:4D3ED88B-5A01-49F5-9210-DE1572BE0DE7@.microsoft.com...
>|||I guess I was kinda drunk while typing that =) I probably assumed he wanted
to delete the database itself.
However it could work in terms of disconnecting processes which use the
mentioned table.
Ekrem ?nsoy
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:EC2F8E1B-A7C0-4147-BEE9-D81CAA9BCC8D@.microsoft.com...[vbcol=seagreen]
> Hi Ekrem,
> How detaching and deleting mdf and ldf files can help to drop a table?
> Thanks,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Ekrem ?nsoy" wrote:
>|||How about some constructive advice?
"Ekrem ?nsoy" wrote:

> I guess I was kinda drunk while typing that =) I probably assumed he wante
d
> to delete the database itself.
> However it could work in terms of disconnecting processes which use the
> mentioned table.
> --
> Ekrem ?nsoy
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:EC2F8E1B-A7C0-4147-BEE9-D81CAA9BCC8D@.microsoft.com...
>|||I'd check for blocking (sp_who, sp_who2, sp_lock etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mlwallin" <mlwallin@.discussions.microsoft.com> wrote in message
news:5704E6AD-6BEE-421A-98BD-2F8BD177ABB0@.microsoft.com...[vbcol=seagreen]
> How about some constructive advice?
>
> "Ekrem ?nsoy" wrote:
>sql

drop or rename a table problem

I tried to drop or rename a table and it hang up for 5 minutes in Enterprise
Manager. Then I hard close EM and open it again. The table has not dropped
or changed. May I know how else can I drop the table? Thanks.
Use Query Analyzer to drop the table.
drop table <table name>
Regards
Amish Shah
|||Is it in 2000 or 2005?
As you didnt recive do not have persmission error iam ruling it out.
Whats the size of the table, if its huge better dont go for Em method, it
can put the EM in hung state. Use
"DROP TABLE tablename" in query analyzer.
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"00KobeBrian" wrote:

> I tried to drop or rename a table and it hang up for 5 minutes in Enterprise
> Manager. Then I hard close EM and open it again. The table has not dropped
> or changed. May I know how else can I drop the table? Thanks.
>
>

drop or rename a table problem

I tried to drop or rename a table and it hang up for 5 minutes in Enterprise
Manager. Then I hard close EM and open it again. The table has not dropped
or changed. May I know how else can I drop the table? Thanks.Use Query Analyzer to drop the table.
drop table <table name>
Regards
Amish Shah|||Is it in 2000 or 2005?
As you didnt recive do not have persmission error iam ruling it out.
Whats the size of the table, if its huge better dont go for Em method, it
can put the EM in hung state. Use
"DROP TABLE tablename" in query analyzer.
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"00KobeBrian" wrote:

> I tried to drop or rename a table and it hang up for 5 minutes in Enterpri
se
> Manager. Then I hard close EM and open it again. The table has not droppe
d
> or changed. May I know how else can I drop the table? Thanks.
>
>

drop or rename a table problem

I tried to drop or rename a table and it hang up for 5 minutes in Enterprise
Manager. Then I hard close EM and open it again. The table has not dropped
or changed. May I know how else can I drop the table? Thanks.Use Query Analyzer to drop the table.
drop table <table name>
Regards
Amish Shah|||Is it in 2000 or 2005?
As you didnt recive do not have persmission error iam ruling it out.
Whats the size of the table, if its huge better dont go for Em method, it
can put the EM in hung state. Use
"DROP TABLE tablename" in query analyzer.
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"00KobeBrian" wrote:
> I tried to drop or rename a table and it hang up for 5 minutes in Enterprise
> Manager. Then I hard close EM and open it again. The table has not dropped
> or changed. May I know how else can I drop the table? Thanks.
>
>