Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Timeout in SP

Author  Topic 

deepabalasubramanian
Starting Member

21 Posts

Posted - 2001-09-24 : 01:56:12
I have 7 Tables with morethan 7 lakh records.
I have a single Stored Procedure that will delete the records in all the tables in a stretch.
But When that sp is called,It gets timeout. i have set the time out to zero.So, my records are not deleted.
Can i Split that SP to 7 SP's or what else option is good

   

- Advertisement -