Answer 1

Yes, it has been available in SS2005 but seems like MS removed it  from SSMS 2008

Answer 2

Hi Robert,

Do you want to get the Created date for a view in Microsoft SQL Server Manager Studio 2008?

If so, we can follow these steps:

Then, we will get the 'Create date' from the 'Description' list.

Or, please use the T-SQL to get the Created date:

USE <database>
GO
/****** Script for SelectTopNRows command from SSMS ******/SELECTTOP 1000 [name]
   ,[object_id]
   ,[principal_id]
   ,[schema_id]
   ,[parent_object_id]
   ,[type]
   ,[type_desc]
   ,[create_date]
   ,[modify_date]
   ,[is_ms_shipped]
   ,[is_published]
   ,[is_schema_published]
 FROM [sys].[all_objects]
 WHERE [name]= '<view name>'

Or use the following query to get all views:

USE <database>
GO
/****** Script for SelectTopNRows command from SSMS ******/SELECTTOP 1000 [name]
   ,[object_id]
   ,[principal_id]
   ,[schema_id]
   ,[parent_object_id]
   ,[type]
   ,[type_desc]
   ,[create_date]
   ,[modify_date]
   ,[is_ms_shipped]
   ,[is_published]
   ,[is_schema_published]
 FROM [sys].[all_objects]
 WHERE [type]= 'V'

If you have any more questions, please feel free to ask.

Thanks,
Jin Chen

Answer 3

Hi Jin

Yes , actually on all objects  you can right click and get that info. It was comfortable to see created date for all objects at glance,

BTW

*fromsys.views  will also dispaly that info

select

Answer 4

SELECT * FROM sys.views
SELECT * from sys.objects WHEREtype = 'V'

You can also have Updated date. I think it was not available in SQL Server 2000.

Answer 5

Hi Jin,

As Uri explained it was great to see the Created Date at a glance and since much of my job is to send my clients SQL Scripts I was previously able to sort my Views by Created Date and script those done after the last Database update.

Now I have to keep track of both the altered and newly created Views which is more time consuming and prone to error if I miss a newly created View.

Bad news for me as a developer at the moment but I only have 1 customer who has migrated to SQL Server 2008.

Thanks for your input it puts my mind at rest anyway.

Robert, Edinburgh

Answer 6

Hi Robert,

What about opening the 'Object Explorer Details'(View > Object Explorer Details')? Does this help?

Thanks,
Jin Chen