How to find a stored procedure by Author's HostName or LoginName

Mphirana

Hi I want to get all the proc names that were created or modified by a specific user or from a specific computer in the database. Thank you

Lost User

I would guess you are using Sql Server. AFAIK, there is no way to do so. The sys.procedures table does not show any field that matches what you request. There is, see post below;

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

CHill60

Closest I can think of is to list the SPs by "owner" ...don't think it's what you're after though. E.g.

exec sp_stored_procedures @sp_owner = 'dbo'

Or you could try using a log reader

Lost User

:thumbsup:

SELECT *
FROM sys.fn_dblog(NULL,NULL)

..but only if there's a decent log, and if they did not log in using the sa-account.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

Kornfeld Eliyahu Peter

SQL does not! stores information about the person (user) modified any of its object, the only information stored is the last date it modified... You may look into the trc files of the default trace (you may need to enable it), but it is good for a short time as it being overwritten periodically...

Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.