Home » SQL ServerRSS

SQL Server 2008 Management Studio

Been around SQL Server since 7.0 days.

 

In SQL Server 2008 Management Studio I don't seem to be able to display Created Date for Views. I can't really believe MS have taken this away so hence my Q.

 

I find it useful to see Created Data to script my recently developed View and other objects.

 

Robert, Edinburgh

 

 

 

6 Answers Found

 

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:

Expand the views from 'Server'  >  'Databases'  >  '<user database>' > 'Views' Right-click the view we want to get the created date Click 'Properties'

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


Best Regards, Uri Dimant sql  Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

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

 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter