Ahhh, this was resolved by changing the username to lowercase - thanks

I have followed the instructions and set the postgres folder with full control for the Users group under Security but get the following error when upgrading from 15 to 16..

Performing...

• This reply was modified 1 month, 3 weeks ago by  shaba.
• This reply was modified 1 month, 3 weeks ago by  shaba.

Thanks lowell, heres the trigger...

Note: addedd an extra ' to the code line

'select getdate(),replace(suser_sname(),'ukdngroup\'',''),'

as was not displaying colors correctly on this site.

Correct code =

'select getdate(),replace(suser_sname(),'ukdngroup\',''),'

ALTER...

I think it would work quicker if the trigger send the inserted and deleted tables to a stored procedure. Then the trigger would be free and the stored procedure...

How would I write a routine to return previously modified field values inc user and date/time?

Thanks John...

I have to use temp tables as the trigger tables (inserted and deleted) are not visible when using dynamic sql.

I did originally send all row data from...

I have managed to get the correct data to write to the audit table by placing the IF EXISTS clause and the UPDATE statement within the same dynamic sql. ...