How to get a list of database objects changed between specific time sql server

 Admin   
202 View    Jan 10 2020 6:31PM

 

Can someone please help me find out,

 

How to get a list of database objects changed between specific time?

 

I'm intrested in finding out.

 

name of the table(if schema is changed)

 

name of the stored Procs

 

Ans:Yes we can as below

 

 

select * 

from sys.objects 

where 

  and modify_date > dateadd(d, -3, getdate()) 

 

select * 

from sys.objects 

where (type = 'U' or type = 'P') 

  and modify_date > dateadd(d, -3, getdate()) 

 

select * 

from sys.objects 

where (type = 'U' or type = 'P') 

  and modify_date > dateadd(m, -3, getdate()) 

 

select * 

from sys.objects 

where (type = 'U' or type = 'P') 

  and modify_date > dateadd(y, 1, getdate()) 

 

Thank You For Visit web.