I have a site that has been created using the asp.net membership schema. I want to set up a trigger on the aspnet_users table that inserted the user_id and the user_name of the new row into another table.
How can I get the values from the last insert?
I can select by the last date_created but that looks smelly.
Is there any better way?