SQL Statment to find out the Objects modified in given date

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 1

There's no way to do this. The change date isn't tracked.

Prakash Heda SSCertifiable Points: 5539 More actions · Answer 2

if you are using sql 2005 u r in luck....it maintains the versions...

try this command and you can see how many times a procedure created...

select * from syscomments c, sysobjects o

where o.xtype not in ('S', 'U')

and o.id = c.id and o.id = object_id(' ')

Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA