I deployed some Sequence objects on production database and after couple of days, I was facing some problem with Sequence objects. It was little difficult to debug all sequence objects at once, so I thought of checking the sequence objects modified dates to find if I modified any Sequence object after deployment.
Given below are the two methods to find the modified dates of Sequence Object.
METHOD 1 : Using sys.sequence
Given below is the script to find the modified date of all sequence object using sys.sequences
USE AdventureWorks2012 GO SELECT name As [Sequence Name] ,modify_date FROM sys.sequences GO --OUTPUT
METHOD 2 : Using sys.objects
Given below is the script to find the modified date of all sequence object using sys.objects
USE AdventureWorks2012 GO SELECT name As [Sequence Name] ,modify_date FROM sys.objects WHERE [type] ='SO' GO --OUTPUT
SQL Server Portal 