Thanks a lot.

TapKs

Hi!

But how to use it? Which parameters I should check?

TapKs

Dear Chris!

Thank you very much the valuable info. I will do it in SP itself & will check in SQL2K.

Thank you once again for ur valuable suggestion.

TapKs

TapKs

Thanks Chris for giving me the explanation. But how to use SCOPE_IDENTITY() instead of @@identity? Can u give me some examples.

Regds.

TapKs

Thanks Chris!

Yes there is a trigger which inserts the records to anothr table.

But this procedure is creating the record in the table as well as the recoeds in the other...