Hi Paul,

I understand your point about ExecuteScalar() will only "see" one result set, so indeed if my SP contains:-

BEGIN TRY

DECLARE @s-2 INT;

SET @s-2 = 1/0;-- Cause an error

END TRY

BEGIN...

Hi Paul,

I am using SQL Server 2008 (+SP2) 10.0.4000 on Windows 7 (OS=6.1.7600)

The dev env is VS2010 and I have .Net4 configured for the application.

The connection string AppConstants.Instance.strSEIFSAConnectionString (from web.config)...