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

What are the dmvs? : sql server database administration

0 Answers  

What is standby servers? Explain types of standby servers.

0 Answers  

What is ms sql server index?

0 Answers  

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

what is hash table

3 Answers   ILFS, Teledata,




What does dml stand for?

0 Answers  

What are the differences between stored procedure and the dynamic sql?

0 Answers  

What do you do in data exploration

0 Answers   EXL,

Tell me what are cursors and when they are useful?

0 Answers  

Do you know what is user defined datatypes and when you should go for them?

0 Answers  

Can we insert data if clustered index is disabled?

0 Answers  

what are the Prerequisites for Replication?

1 Answers   IBM,

For more SQL Server Interview Questions Click Here
Categories