Hi all,

I would like to discern between ASP internet users within the SQL Server. There is no problem to do the identification using Integrated Windows Authentication, since SUSER_SNAME() returns always correct ID.

Is there anything for Anonymous Access that would do the job? I would like to write a trigger for user activity monitoring of INSERT or UPDATE statements and do it just using SQL Layer.

Thank you in advance for advices!

Anonymous is... anonymous.

Maybe forms authentication is more appropriate since you wouldn't be relying on windows logins for everyone anymore.