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

Why are sql functions used?

1188

Explain what are the different index configurations a table can have?

1170

What is sql server management studio? : sql server management studio

1138

What is bit data type?

1089

How will you hide an attribute? : sql server analysis services, ssas

1020

Explain the difference between primary keys and foreign keys?

1111

How secure is sql server database?

1080

Explain transaction server auto commit?

1092

What is resultset concur_updatable?

1062

What is the order by used for?

1063

What is 'Join' and explain its various types.

1218

What are the system database in sql server 2005?

1107

When is update_statistics command used?

1094

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

1048

What are the types of subscriptions in SQL Server replication?

1120