Modifications Date
-
How do I find out the Modification Dates of my Views on a Database SQL 2000? Thanks in advanced for your help
SELECT Name, CRDate FROM SysObjects WHERE Name LIKE '%YourView%'
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. Vince Lombardi (1913-1970)
-
SELECT Name, CRDate FROM SysObjects WHERE Name LIKE '%YourView%'
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. Vince Lombardi (1913-1970)
-
Thanks for your answer But this is the Creation Date, I'm looking for the Modify Date. Do you have an idea to find de Modify Date??
Sorry, I don't see it in sysobjects, not that it doesn't exists somewhere.
--create
alter view vw_Junk
as
SELECT * from tempdb..tblJunkselect * from sysobjects where type = 'v'
name id xtype uid info status base_schema_ver replinfo parent_obj crdate ftcatid schema_ver stats_schema_ver type userstat sysstat indexdel refdate version deltrig instrig updtrig seltrig category cache
vw_Junk 872153252 V 1 36 1610612736 0 0 0 2007-03-23 07:59:21.897 0 0 0 V 0 2 0 2007-03-23 07:59:21.897 0 0 0 0 0 0 0
vw_Junk 872153252 V 1 36 1610612736 16 0 0 2007-03-23 07:59:21.897 0 16 0 V 0 2 0 2007-03-23 07:59:21.897 0 0 0 0 0 0 0
vw_Junk 872153252 V 1 36 1610612736 32 0 0 2007-03-23 07:59:21.897 0 32 0 V 0 2 0 2007-03-23 07:59:21.897 0 0 0 0 0 0 0There is a sc
-
Sorry, I don't see it in sysobjects, not that it doesn't exists somewhere.
--create
alter view vw_Junk
as
SELECT * from tempdb..tblJunkselect * from sysobjects where type = 'v'
name id xtype uid info status base_schema_ver replinfo parent_obj crdate ftcatid schema_ver stats_schema_ver type userstat sysstat indexdel refdate version deltrig instrig updtrig seltrig category cache
vw_Junk 872153252 V 1 36 1610612736 0 0 0 2007-03-23 07:59:21.897 0 0 0 V 0 2 0 2007-03-23 07:59:21.897 0 0 0 0 0 0 0
vw_Junk 872153252 V 1 36 1610612736 16 0 0 2007-03-23 07:59:21.897 0 16 0 V 0 2 0 2007-03-23 07:59:21.897 0 0 0 0 0 0 0
vw_Junk 872153252 V 1 36 1610612736 32 0 0 2007-03-23 07:59:21.897 0 32 0 V 0 2 0 2007-03-23 07:59:21.897 0 0 0 0 0 0 0There is a sc
Thanks for your help. I found a different way. I made a back up from the database and restored it on a SQL 2005, in the SQL 2005 I have the System View sys.views whit the Creation Date and Modify Data! It’s not a very beautiful way, but it works..... select * from sys.views order by modify_date DESC