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 Posted / 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 View All Answers
explain how to create a new schema in a database? : Sql server database administration
How to check status of stored procedure in sql server?
What is the difference between ‘having’ clause and a ‘where’ clause?
What are the components of dbms?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is the distinction amongst delete and truncate?
How and why use sql server?
What is default constraint?
What type of Index will get created after executing the above statement?
What is resource governor?
How to truncate the log in sql server 2012? : sql server database administration
Explain the difference between function and stored procedure?
What are the parts of a function?
Is sql different from sql server?
How can we solve concurrency problems?