Post reply

***When I try to delete all the records the database table an errorbox appers stating TIMEDOUT.***

  • December 7, 2007 at 5:22 am

    #184737

    Im using a 'bulk insert' to insert 150,000 records into a database table in SQL server 2000. When I try to delete all or some of the records an errorbox appers stating TIMEDOUT.

    Any help would be great, Thanks.

  • December 7, 2007 at 5:31 am

    #758024

    use Query analyser to run the delete.

    Deletes can run for a long time, and the query time is probably exceeding the timeout value for the application that you're using. Query analyser doesn't have any timeout set.

    Edit: You may be getting blocked by another process. Run SP_who2 to see if your delete is blocked by another connections and if so, by who.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 7, 2007 at 5:43 am

    #758028

    You could also do a TRUNCATE if possible.

    --Ramesh

  • December 7, 2007 at 6:22 am

    #758039

    The problem is now sorted, thanks for your help.

    Cheers 😀

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply