Identify modified tables or stored procedures
SQL Server 2008 management tools have a really handy feature, you can order the tables or stored procedures by modified date. I wondered if you could do this in SQL 2005 as it's often difficult to figure out what you've changed without keeping notes. Turns out you can!
Modify the SQL script below to suite your server:
USE yourDatabaseNameHere
GO
SELECT name, create_date, modify_date, type
FROM sys.objects
WHERE type = 'P' or type = 'U'
order by modify_date desc
Column "Type" with a value of 'P' is a stored procedure
Column "Type" with a value of 'U' is a user table