Skip to Content
0
Former Member
Nov 05, 2015 at 03:22 PM

Trouble scope_identity()

119 Views

Working with PB12.6 and SQL Server 2008

Trying to get identity column from Table T1 which fires a trigger to insert in Table T2. I need to get id from T1 but instead get the T2 value.

I tried inserting 'Identity= =Scope_identity()' in the extended properties in the Database profile. Any help would be greatly appreciated. Thanks