>Here is my verion:
>
>SELECT *
>FROM sys.objects
>WHERE type = 'P' and name = 'my_stored_procedure'
>ORDER BY modify_date DESC
>
>
>I have checked that I use the name which is the same in more than one DB. What am I doing wrong?
Sorry,
Naomi point me that you asked about ALL databases.
This select will return SPs from current database only, not from all.
EXEc sp_MSForEachDB'
SELECT ''?'' as DB,*
FROM sys.objects
WHERE type = ''P'' AND Name = ''my_stored_procedure''
ORDER BY modify_date DESC'
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
