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
- 1 Answers
- 3673 Views
- INDUS, I also Faced
- E-Mail Answers
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
what is the system function to get the current user's user id? : Sql server database administration
List out the different types of locks available in sql server?
What is the maximum size of a dimension? : sql server analysis services, ssas
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What is cached report?
What is difference between commit and rollback when used in transactions?
Do you know the isolation level that sql server support?
What is lookup override?
How to sort query output in descending order in ms sql server?
What is named calculation? : sql server analysis services, ssas
How efficient you are in oracle and SQL server?
What is indexed view? How to create it?
Does partitioning ssd reduce performance?
How to create prepared statements using odbc_prepare()?
