Home Forums SQL Server 2005 Administering Multiple logins w. sysadmin (multiple databases/apps)? RE: Multiple logins w. sysadmin (multiple databases/apps)?

  • I would just filter by the app account you are wanting to look at, make sure dbname is one of the columns.

    Maybe add:

    SQl: StmtCompleted and SQL: StmtStarting

    SP: StmtCompleted and SQL: StmtStarting

    Test a transaction, At a high level look for any part of showing use of a database outside of what you would expect and then further into the SQL or SP statements if needed.