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