How To Find That One Week Change in My DataBase we Have Done
Like We Have A database Test I Change Table,Stored Procd.
Then I Find Which SP,Table We Have Edit/Change in Seven
Dayes
Answer Posted / sandeep modapathi
just run this query
SELECT * FROM SYS.OBJECTS
WHERE TYPE='P' AND (CREATE_DATE>'<Date>' OR
MODIFY_DATE>'<Date>')
This query will return all the SPs modified or created
after the date specified. You can change the filter
condition according to your purpose.
For Tables ... use this query
SELECT * FROM SYS.TABLES
WHERE CREATE_DATE>'<Date>' OR MODIFY_DATE>'<Date>'
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the phases a transaction has to undergo?
If no size is defined while creating the database, what size will the database have?
What is the difference between rank and dense_rank?
If a table does not have a unique index, can a cursor be opened on it?
Explain why variables called the most powerful component of ssis?
what is normalization? : Sql server database administration
How you can change the database name in SQL SERVER?
What is difference between count (*) and count column?
How to round a numeric value to a specific precision?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is master database? : SQL Server Architecture
What is a covered index?
When multiple after triggers are attached to sql table, how to control the order of execution?
Can you explain different types of locks in sql server?
Define left outer join?