What really is a patch?

A patch is a small release of source code that fixes a specific (and usually critical) issue in a product. Patches are also usually released outside of a normal release cycle due to an urgent issue.

http://stackoverflow.com/questions/2446644/what-really-is-a-patch

When was the Table, View, Proc, … created or modified

On my previous blog posts [link] I discussed about System Catalog views and some tips to get the informaion regarding Database objects, like: Tables, Views, etc.

Adding to that post, this post provides the basic information that various DBAs & Developers are interested in, i.e. when was the Table created? or When was that particular Stored Procedure modified or updated?

Following set of queries provides this information:

01	select object_id, name, create_date, type_desc, modify_date

02	from sys.tables

03

UNION

04	select object_id, name, create_date, type_desc, modify_date

05	from sys.views

06

UNION

07	select object_id, name, create_date, type_desc, modify_date

08	from sys.procedures

09

UNION

10	select object_id, name, create_date, type_desc, modify_date

11	from sys.triggers

-OR- a single query to check all objects information:

1	select object_id, name, create_date, type_desc, modify_date

2	from sys.all_objects

3	where type in ('U', 'V', 'P', 'TR' ,'FN', 'IF', 'TF')

4	order by type, name

By querying the sys.all_objects view you can also get the information about other DB objects other than listed above, like: Indexes, Constraints, Synonyms, Stats, etc.

MS BOL link on sysobjects and object-type codes: http://msdn.microsoft.com/en-us/library/ms177596.aspx

http://sqlwithmanoj.wordpress.com/tag/system-catalog/