65.9K
CodeProject is changing. Read more.
Home

I don’t know why my boss always gets angry

starIconstarIconstarIconstarIconstarIcon

5.00/5 (3 votes)

Jun 14, 2011

CPOL
viewsIcon

9451

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.