Thanks a lot for the quick turn around.

I guess my question was. If I have 5 databases on my server & I want this trigger to only on one database.

since we are doing "ON ALL SERVER FOR LOGON" this does restrict all logins to that server. Instead I want to protect only my database and let the user login to other databases in the server.

Servername : prod1

databases : db1, db2, db3, db4, db5

I just want to restrict logins to db1 I am not concerned about the other databases.

Thanks