1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / dinesh sharma


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

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

What are database states in ms sql server?

0 Answers  

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

0 Answers  

Can we install sql server 2016 on windows 7?

0 Answers  

Is it safe to delete log files?

0 Answers  




Mention the differences between local and global temporary tables.

0 Answers  

Do you know what is difference between index seek vs. Index scan?

0 Answers  

Is mysql the same as sql server?

0 Answers  

What is user defined stored procedures?

0 Answers  

What is sleeping status in sql server?

0 Answers  

What are various aggregate functions that are available?

0 Answers  

What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  

For more SQL Server Interview Questions Click Here
Categories