I don’t know why my boss always gets angry





5.00/5 (3 votes)
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.