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 / 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 |
What triggers long term care?
In which tcp/ip port does sql server run? Can it be changed?
Why I am getting this error when renaming a database in ms sql server?
what is normalization? what is denormalization?
How to start and end transact-sql statements?
Tell me what are cursors and when they are useful?
Explain what are page splits? : SQL Server Architecture
How to see the event list of an existing trigger using sys.trigger_events?
If there is failure during updation of certain rows, what will be the state?
How can we improve performance by using SQL Server profiler?
What is the default Port No on which SQL Server listens?
What are the security related catalog views? : sql server security