just run this query SELECT * FROM SYS.OBJECTS WHERE TYPE='P'

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 / sandeep modapathi

1 Answers
4197 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

Please Help Members By Posting Answers For Below Questions

What are sql servers used for?

979

What are different types of table joins?

960

What is transaction server distributed transaction?

976

What is a DBMS, query, SQL?

995

How do I view a stored procedure in sql server query?

885

List the data types available in mssql?

957

What are the new features of sql server 2008 r2 reporting service?

193

What is filestream?

942

What is an example of a foreign key?

926

What is the sql server 2000 version number?

1007

How to truncate the log in sql server 2012? : sql server database administration

1199

What does COMMIT command do?

1006

Can we linked SharePoint to a SQL database?

970

what are the different ways to return the rowcount of a table?

942

How to use union to merge outputs from two queries together in ms sql server?

1006