Click here to Skip to main content
15,908,673 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Is it possible to say that a complex stored procedure never meets with time out error??

The stored procedure is going to be executed by .net command class.



Any reply will be apperciated....
Posted

Of course a stored proc can be made to time-out. Assuming you have a proerly designed and constructed database, along with a stored proc that actually works, it shouldn't time-out. Try running the stored proc inside sql manager express and see how long it should take to run.
 
Share this answer
 
Stored procedure is a set of Structured Query Language (SQL) statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs. The use of stored procedures can be helpful in controlling access to data (end-users may enter or change data but do not write procedures), preserving data integrity (information is entered in a consistent manner), and improving productivity (statements in a stored procedure only need to be written one time).

Itz nothing related to .NET framework
 
Share this answer
 
Of course it might time-put. Use BEGIN TRY and BEGIN CATCH in SQL and make sure that you ROLLBACK those transactions when it fails or time-out.

Regards,
Eduard
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900