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.
| Author |
Topic |
|
mary_itohan
Posting Yak Master
191 Posts |
 Posted - 2008-09-01 : 16:27:18
|
| Hello guysWhat is the max Execution time for a SP ? And is there any way of extending it.If am running inserts in a very large table running into millions of updates. Whats best to use.I tried using a scalar function, but cant. Please advicetnxYes O ! |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2008-09-02 : 00:24:23
|
| I am not aware of any max execution time limitation. PLease describe what you are trying to do and provide some sample data. |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-09-02 : 00:44:26
|
if you are running the proc from a client API such as ADO.NET then there are timeouts you can set that will be hit if the query runs long. For example, the timeout on System.Data.SqlClient.SqlCommand is 30 sec IIRC.if you are just running the proc by hand from SSMS there is no timeout.
elsasoft.org |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-02 : 04:48:43
|
| You can also set the property of the timeout in .net by assigning a new property to it at runtime. |
|
|
|
|
|
|
What is the max Execution time for SP