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
- 3462 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 encrypt data between dialogs?
what are database files and filegroups? : Sql server database administration
What is normalization according to you and explain its different levels?
What is a with(nolock)?
What are built in functions?
Explain the disadvantages/limitation of the cursor?
What is the function of inner join?
Why I have to use stored procedures?
What is it unwise to create wide clustered index keys?
What are the key configuration files for sql server reporting services ?
What is cursors?
What are system databases in ms sql server?
Explain relational data?
What is the advantage of sql server?
What is the difference between online clustering and Offline clustering?
