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 |
|
vgselva
Starting Member
4 Posts |
 Posted - 2009-01-05 : 05:02:03
|
| I like to know about the execution Status of Stored procedures.Before Executing the Procedure or at the beginning of execution is it possible to know the No.of Records the Stored Procedure may produce as a Output using the Execution Plan.In case of Larger execution time, Current Record Counts that are currently in processing should be know.Need Suggestion for an ERP development...(Having Larger Execution time of stored procedures ... to Produce a Progress Bar for the User Interaction)V.G.Selvakumar |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-05 : 05:22:36
|
No, you can't.The returning resultset (aka "output" as you call it) depends on many factors. Mainly how many records there are in the involved tables, but also JOINs, WHEREs, GROUP BYs and so on.Other factors are parameters used in the above mentioned cases.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Stored Procedure Execution Status