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
4332 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

Explain few of the new features of sql server 2008 management studio

918

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1396

How to provide values to stored procedure parameters in ms sql server?

1037

How you can change a cross join into an inner join?

973

What is difference between inner join and full join?

1067

Explain ranking functions?

1046

How to create a simple stored procedure in ms sql server?

1027

What is difference between primary key and foreign key?

904

Define full outer join?

955

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

987

How to receive returning result from a query?

1124

Write a code to select distinct records without using the DISTINCT keyword.

1114

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1076

What is the index requirement in SQL Azure?

How many columns can we include on clustered index ?

990