You are here: Re: Why I can't drop a table « MsSQL Server « IT news, forums, messages
Re: Why I can't drop a table

Posted by Scarab on 10/06/74 11:34

Thanks for your reply, how can i find out who is accesing the table? Thanks


"Greg D. Moore (Strider)" <mooregr_deleteth1s@greenms.com> wrote in message
news:pl6nf.2746$3Z.1361@newsread1.news.atl.earthlink.net...
>
> "Scarab" <yw@lucent.com> wrote in message
> news:dnijpb$f0k@netnews.net.lucent.com...
> > Hi,
> > When I drop a table in Sqlserver 2000 database, The following error
> occurs:
> >
> > Server: Msg 1204, Level 19, State 1, Line 1
> > The SQL Server cannot obtain a LOCK resource at this time. Rerun your
> > statement when there are fewer active users or ask the system
> administrator
> > to check the SQL Server lock and memory configuration.
> >
>
> Someone else is accessing the table.
>
>
> >
> > What's wrong? Any help is greatly appreciated, thanks.
> >
> >
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация