I have a requirement wherein to automate a process that when a new login is created in SQL Server 2005, I need to execute code to add the newly created username to another user table in my database.
I am aware of the system tables that can be queried to pull out the list of logins that exist in SQL Server database and identify any newly created logins.
However, I am looking at an alternate solution that allows me to get notified when a new login is created. It would be more like a trigger. Since I am dealing with system tables, I don't want to user triggers on system objects.
I have come across SQL Server Notification Service but I am not sure if it would be an appropriate feature to use for such a requirement.
If anyone knows of a better solution or if SQL notificaition services can be used for this, please share your thoughts.
View Complete Post