Sign Up Login


  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

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

What is index?

1 Answers   Cap Gemini,

How to get the definition of a user defined function back?

0 Answers  

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  




Explain trigger and its types?

0 Answers  

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

Define the term DML, DDL and DTL?

1 Answers  

What is statement level trigger?

0 Answers  

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

When do u use clustered index and non-clustered index?

3 Answers   IBM,

What is user-defined function?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories