Home Forums SQL Server 2005 SQL Server 2005 Security What's the most efficient way to find out which logins connect to a Database in SQL server 2005 RE: What's the most efficient way to find out which logins connect to a Database in SQL server 2005

  • A server-side trace has minimal impact and would be the way I'd recommend going about it on SQL 2005.

    All DDL triggers, including LOGON triggers are AFTER triggers, so changing from FOR LOGON to AFTER LOGON actually doesn't change anything.