Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

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

Home
Forums

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

krunal pande

8yAsked Jan 10, 2018, 7:48 AM772

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Nitin Sontakke8y ago
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'''