In SP , we have implemented below events :-

DDL_LOGIN_EVENTS

, DDL_GDR_SERVER_EVENTS

, DDL_AUTHORIZATION_SERVER_EVENTS

, CREATE_DATABASE

, DROP_DATABASE

, ALTER_DATABASE

Even though DDL_LOGIN_EVENTS implemented in SP , we are not able to capture the Create login script in table.

I have attched the server trigger , please find attached sp and assist me.