SQL Server 2003 tables hanging up on execute and Cant drop tables
Posted on 2007-03-30
I have a SQL 2003 database, for some reason three tables within the database are hanging up. If I execute a query against them, it takes a long time to execute and waits for a response from data source, for a simple query such as
Where LoanId = 823
Once it executes after 20 seconds I get SQL Execution Error.
I wanted to just delete the tables and bring them into SQL from another database, but I cant even delete them. Any ideas on solving this?