sanketahir1985 (2/8/2010)
...hiii RBarryYoung,
on my server its going beyond 21 loops
so finally i have to kill this SP
tell me exactly whether this SP goes in infinite loop or will finish after some time?
No, that is correct, this script will run until you kill it. That is quite typical for a "script to generate load" as you requested. For instance, Jeff's script *will* finish "sometime", but that "sometime" could take several days. If this is not what you want then please let us know.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]