Home Forums SQL Server 2005 Administering How to findout who has modified the Stored procedures recently RE: How to findout who has modified the Stored procedures recently

  • It does provide the db_id and the object_id and you can use that information to get that information. YOu would need to execute the query in the user database.

    Other than creating a DDL trigger I don't know of any other way to get this information.