Urgent help-IDentity column

[sdh]

on a replicated db this has started to return NULL
for scope_identity any ideas why?


INSERT

INTO "dbtophorse"."dbo"."tbOrder"("tbOrd_total","tbOrd_datetime","tbUsr_id","tbshipingID")
VALUES(@orderTotal,GETDATE() ,@User,@tbshippingId)

SET @tbOrd_id=Scope_Identity()

Thanks
SDH

 

[JamesLean]

The only time SCOPE_IDENTITY will return NULL is if you haven't inserted into a table with an identity column yet. Are you sure the tbOrder table still has an identity column?

--James

 

[sdh]

Yes

If i append return @tbOrd_id to my sp I get a value
on the replication master
However on the replicated databases running the same procedure I get NULL