i want that database name in which changes done in SP .

Question

Hi team i have one sp in all databases having name '[TNA].[ATTENDANCE_MAIL_ALERT_SUMMARY_DETAILS_TO_EMPLOYEE]' but in some databases changes done in sp i want that database name in which changes done. Please look into this and revert . Thanks & Regards Krunal Pande

Nitin Sontakke · Answer

You can use following script: use [master] go execute sp_MSforeachdb N 'use [?]; select db_name() [database] name create_date modify_date from sys.objects where name = ' 'ATTENDANCE_MAIL_ALERT_SUMMARY_DETAILS_TO_EMPLOYEE' ''