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
- 3243 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
How to get a list of columns in a view using the "sp_columns" stored procedure?
Is null vs coalesce?
What is primary key and example?
How to convert numeric values to integers in ms sql server?
How does clustered and non clustered index work?
What do you mean by tablesample?
Can I disable or restrict ssrs export formats (rendering formats)?
What is an active database?
What do you understand by mirroring?
How you can add messages to the nt event log from within a stored procedure?
Do comments need to go in a special place in sql server 2005?
What is the fastest way to permanently delete a 1 million row table named customers?
Introduction of rollup clause using sum and group by clause?
How to Check if table exists in sql server?
What are the 10 characteristics of data quality?
