December 10, 2008 at 12:11 pm
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
December 10, 2008 at 1:03 pm
You can get that info from the default trace. Here's an article with sample queries of the trace: http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/. You can also see the most recent changes in SSMS by right-clicking on the database -> Reports -> Schema Changes History.
Greg
December 10, 2008 at 10:35 pm
select * from sys.objects
where type = 'U' or type = 'P'
and modify_date between '2008-12-01' and '2008-12-11'
May 7, 2012 at 3:55 am
Hi All,
The code provided below will give me the list of objects which are modified on provided date range.... But how to get what all changes has done in that duration.
Like in a Table Object, If a new column is added or removed how do we know this is the reason of modification or any other reason.
Is there any t-sql query through which we find out the list of changes in a particular object.
select * from sys.objects
where (type = 'U' or type = 'P')
and modify_date between '2012-03-14' and '2012-05-07'
May 7, 2012 at 5:39 am
Query your source control system. You do put database objects into source control...?
p.s. Please post new questions in a new thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply