Is it possible to get the user who last edited a stored proc, function, table or view in SQL Server?

Question

I'm not even sure SQL Server stores this kind of information, but, is it possible to get the username of the person who last modified a particular stored procedure, function, table or view?

Nothing critical, just wondering. Thanks!

Answer 1

If you are using SQL Server 2008, you could use some new features that allow you to put triggers on DDL changes. You can then track, based on the authenticated user, who made the change.

I think these triggers are new to SQL 2008, but they may be available in 2005.

Having said this, ideally you should have your database schema under source control, using a tool like Visual Studio Database Professional. Then you'd have a complete history of who did what and when.

Randy

Answer 2

It doesn't store this information out of the box.

You can use SQL Trace and Event notification (see the corresponding MSDN Article) to log this kind of information by yourself.

I have no experience with these technologies though ...