Posted by Hugo Kornelis on 12/06/12 11:26

On Mon, 12 Sep 2005 13:56:43 GMT, vassone wrote:

(snip)
>The code I'm using is below and this keeps giving me "Multiple-step OLE DB
>operation generated errors. Check each OLE DB status value, if available. No
>work was done."

Hi vassone,

Try adding the command
SET NOCOUNT ON
as first command in the stored procedure (i.e. directly after the AS
keyword, before the INSERT)

CREATE PROCEDURE name
@parm datatype [OUTPUT],
...
AS
SET NOCOUNT ON
INSERT INTO table (...)
VALUES (...)
SET @output_var = SCOPE_IDENTITY()
GO

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[Back to original message]