Very Computer

Hello All,

'return' is used to return the error code ).

All the procedures are working fine.. except for one which always returns a
value 2 greater than the actual identity of the row inserted.

e.g. if the procedure returns 82.. the actual identity for the row inserted

identity is 83.

What could be the cause and how do i correct this behavior??

thanx

Hello All,

'return' is used to return the error code ).

All the procedures are working fine.. except for one which always returns a
value 2 greater than the actual identity of the row inserted.

e.g. if the procedure returns 82.. the actual identity for the row inserted

identity is 81.

What could be the cause and how do i correct this behavior??

thanx

Perhaps there's a trigger on the table in which you INSERT to and that trigger has an insert as
well? If you are on SQL2K, use SCOPE_IDENTITY instead. If on 7.0, search KB as there's an
article on the subject.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...

Nabeel,

What version of SQL Server are you running? Could you send the part of the

Thanks,

Paresh Chobhe

The posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

--------------------


| Date: Thu, 18 Apr 2002 13:16:33 +0500
| Lines: 23
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000

| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: 202.125.137.179
| Path: cpmsftngxa08!cpmsftngxa07!tkmsftngp01!tkmsftngp07
| Xref: cpmsftngxa08 microsoft.public.sqlserver.programming:251464
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
| Hello All,
|

|
| the stored procedure i'm using to insert data into a table should return
the

and
| 'return' is used to return the error code ).
|
| All the procedures are working fine.. except for one which always returns
a
| value 2 greater than the actual identity of the row inserted.
|
| e.g. if the procedure returns 82.. the actual identity for the row
inserted

| identity is 83.
|
| What could be the cause and how do i correct this behavior??
|
| thanx
|
|
|
|
|
|