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

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

1022

Explain what is public role in sql server?

1192

What are the differences between decimal and float in ms sql server?

1349

What types of Joins are possible with Sql Server?

1192

Can we install sql server 2016 on windows 7?

1199

What are the difference between primary key and unique key? : sql server database administration

992

What is a fan-out query in SQL Azure?

123

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

1041

Can you use order by when defining a view?

1022

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2168

List out a number of the wants to setup a SQL Server failover cluster?

1123

What are Row versions of DataRow?

1082

How many null values we can have in a unique key field in sql server?

1011

What is a database table?

1025

What is page in sql server?

996