Not receiving all emails

[CS]

I have a stored procedure which sends out an email to all the users
listed in the database. for some reasons I am not getting all emails.
could someone offere some assistance?

Here's my code. Global.asa

Sub Session_OnStart
'==Visual InterDev Generated - DataConnection startspan==
'--BCSI Data Connection
Session("TMS_Co nnectionString" ) = "DSN=Test"
Session("TMS_Co nnectionTimeout ") = 60
Session("TMS_Co mmandTimeout") = 60
Session("TMS_Ru ntimeUserName") = " "
Session("TMS_Ru ntimePassword") = ""
End Sub
My asp page:

Set cnTMS = Server.CreateOb ject("ADODB.Con nection")
cnTMS.Connectio nTimeout = Session("TMS_Co nnectionTimeout ")
cnTMS.CommandTi meout = Session("TMS_Co mmandTimeout")
cnTMS.Open Session("TMS_Co nnectionString" ),
Session("TMS_Ru ntimeUserName") , Session("TMS_Ru ntimePassword")

Set rsTMS = Server.CreateOb ject("ADODB.Rec ordset")
Set cmdTMS = Server.CreateOb ject("ADODB.com mand")
cmdTMS.CommandT ext = " "
'
cmdTMS.CommandT ext = "Exec Test_ResStaffEm ail"
'
cmdTMS.CommandT ype = 1
Set cmdTMS.ActiveCo nnection = cnTMS
rsTMS.Open cmdTMS, , 1, 3

'
' rsTMS.Close
'
Set cmdTMS = Nothing
Set rsTMS = Nothing

Am i missing somethins as it is supposed to send out 90 emails but i
receive only 5? Teh stored procedure is getting executed but the mails
are not coming through.

Thanks

[Anthony Jones]

It's difficult to say with knowing the content of the SP.

I'm not sure this is an appropriate place for the question it's doubtful
that the problem really lies in the realm of ASP.

Why doesn't the SP CURSOR through the set records for emailing rather than
have a VBScript do it?

Anthony.