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 

Answer 1

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'''