Member Avatar for ptaylor965
ptaylor965 6 Junior Poster

Hi

We have got a single instance of SQL Server 2005. The latest service pack 3 has been installed today. Since installing SQL Server two months ago we are finding that SQL Server times out if you try to delete records from any table that has more than 600,000 records.

So on our table with 1 million records if we say "DELETE FROM tbl" then it times out. Deleting the Top say 600,000 records works.

We do not want to use TRUNCATE as this would mean modifying lots of code in our application.

Also the same promlem is experienced when using UPDATE.

Many thanks for your help

  • 1 Contributor
  • 0 Replies
  • 204 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.