You should be getting a value if the stored procedure performs an UPDATE, INSERT or DELETE, -1 is returned for any other statements. Is it possible you have a SELECT statement there after the UPDATE statement?
Roman
>Anyone know if I should be getting a value (other than -1) when ExecuteNonQuery is called to execute an sql server stored procedure that is doing an update command?
>
>
>Thanks,
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729