StoredProc from vb code

zdraweite, imam sledniqt problem, vikam sp na MS SQL:

cn.Execute .Fields("SP_Name").Value, lngRecordsAffected
'.Fields("SP_Name").Value -> sydyrja imeto na procedurata
'lngRecordsAffected -> 4akam kolko zapisa e obrabotila

ako proc se vikat ry4no - minavat, a taka - ne. vyv lngRecordsAffected vryshta 0.
iavno problema e neshto v SQL srv, zashtoto samo na edin ot tiah se proiaviava tozi "efekt".
procedurite sa tranzakcionni!

ako niakoi moje, molia pomagaite...

Много малко информация си дала. Единственото което се сещам е да си провериш за SET NOCOUNT ON евентуално.

I think its kinda funny I think its kinda sad the dreams in which Im dying are the best Iv ever had