Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / database / SQL-Server

I don’t know why my boss always gets angry

5.00/5 (3 votes)
14 Jun 2011CPOL 9.5K  
Why don't you just use a query like this?SELECT CAST(serverproperty(N'servername') AS varchar(50)) AS [Server Name], db_name() AS [Database Name], SCHEMA_NAME(schema_id) AS [Schema Name], [name] AS [Object Name], [type_desc] AS [Object Type], [create_date] AS [Create...
Why don't you just use a query like this?

SELECT 
	CAST(serverproperty(N'servername') AS varchar(50)) AS [Server Name],
	db_name() AS [Database Name],
	SCHEMA_NAME(schema_id) AS [Schema Name],
	[name] AS [Object Name],
	[type_desc] AS [Object Type],
	[create_date] AS [Create Date],
	[modify_date] AS [Modified Date]
FROM sys.all_objects
WHERE
	[is_ms_shipped] = 0
ORDER BY
	[modify_date]


That will tell you the create date PLUS the modified date. You can easily filter the list by adding qualifiers to the WHERE statement.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)