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



How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change ..

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

Post New Answer

More SQL Server Interview Questions

What triggers long term care?

0 Answers  


In which tcp/ip port does sql server run? Can it be changed?

0 Answers  


Why I am getting this error when renaming a database in ms sql server?

0 Answers  


what is normalization? what is denormalization?

9 Answers   Satyam,


How to start and end transact-sql statements?

0 Answers  






Tell me what are cursors and when they are useful?

0 Answers  


Explain what are page splits? : SQL Server Architecture

0 Answers  


How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  


If there is failure during updation of certain rows, what will be the state?

2 Answers  


How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,


What is the default Port No on which SQL Server listens?

0 Answers  


What are the security related catalog views? : sql server security

0 Answers  


Categories