I am having a timeout issue. My application call a T-SQL stored procedure to delete several hundred thousand records after a process has been completed.
650,000 not unusual.

The code for the T-SQL is a no-brainer

DELETE FROM CardDetail
WHERE BCDGAME=@GameNbr and BCDGameDate = @Date_Id and BCDGameCntrl = @Seq_Id.

I have a try/catch to trap this and get this error

{"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}

None of the records have been deleted. How do I get around this??

Thanks

gollnick