Daily Archives: April 25, 2013

Query to get last modified procedures or table names in sql server

These are the some basic sql queries which helps during the development process. In order to get top 10 procedures names which are modified recently you can use SELECT top(10)OBJECT_NAME(object_id) as name,modify_date,type_desc,create_date FROM sys.objects WHERE type = ‘P’ ¬†Gives you last 10 modified procedure names SELECT top(10)OBJECT_NAME(object_id) as name,modify_date,type_desc,create_date FROM sys.objects WHERE type = ‘U’ […]