Is there a way to list who created certain procure in SQL Server 2008?
In this SO link there are some answers but from 6yrs ago.
I know it's a best pratice to write your name and date, and then start to create the procedure, but I don't see this where I work.
If there is no way to do this, can this task be made with triggers?
And a bonus question. Is this the job, of a dba? to know who created it?
Thank you very much.
Best Answer
Yes there is a way
The table to store the results of the trigger
The trigger
The Query to Audit the results of the trigger
Another DBA might have a different opinion, but I consider having this information readily available as important for a DBA.