Unfortunately I cannot get an imbedded image or a code snippet to format properly so I have to format the question using Word and DropBox ... sorry.

https://www.dropbox.com/s/m9az2zk4mlihh4d/ExecuteScalarQuestion.docx

Thanks in advance.

C. T.

Charles T. Blankenship
Senior Consultant
Novant Consulting, Inc.
704.975.7152
http://www.novantconsulting.com

Hi Charles,

Try adding the following at the top of your stored procedure.

SET NOCOUNT = ON

Edhy Rijo

Thanks Edhy:

SET NOCOUNT ON was 50% of the solution … adding the SELECT @@ROWCOUNT beforethe COMMIT TRAN was the other 50%

C. T.




Charles T. Blankenship
Senior Consultant
Novant Consulting, Inc.
704.975.7152
http://www.novantconsulting.com

Hi Charles,

Glad it helped out.

Edhy Rijo