Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dkim88
Starting Member
2 Posts |
 Posted - 2011-07-26 : 17:28:24
|
| Hello,I have a client that has had something happen on their database or some kind of automated third party application that is affecting one of the tables on the database. They know it started happening after a certain date.Is there any way to search through SQL Server for any type of stored procedure or trigger or anything similar that was created or inserted on or before that date? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-07-26 : 17:45:34
|
| You can use sys.objects (select * from sys.objects) which has a create_date and a modify_date column. Also, information_Schema views give you information on views, tables, stored procs etc. For example, INFORMATION_SCHEMA.TABLES. |
 |
|
|
dkim88
Starting Member
2 Posts |
Posted - 2011-07-27 : 10:13:10
|
| oh okay, that's very helpful. thank you! |
|
|
|
|
|
|
Searching for SP/TR by created / inserted date