Is Drop Procedure a logged transaction?

[cbhnp]

If a stored procedure is dropped, a record would be deleted from the syscomments table. Would a log reader find that transaction to determine the user that dropped it?

Or aren't transactions in system tables logged?

 

[mrdenny]

Yes the DROP PROCEDURE command is logged. A log reader should be able to show you who dropped the procedure.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog