On Thu, Feb 12, 2009 at 10:17 AM, Matt Jarvis <[email protected]> wrote:
> I was making some changes to various things last week, such as SP's and
> whatnot, and as it happens we are getting some oddball data problems
> cropping up. We also had a personnel change as well so that may be the
> problem i.e. training issue.
>
>
>
> I backed out my changes as far as I know. But is there a way to ask the
> thing (SQL Server 2K ) what is the last datetime something was touched
> so that I can go back and double check my rollbacks?
>
----------------------------------------------
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE last_altered >= dateadd(d, -15, GETDATE())
I just plugged in teh lst 15 days here. This will give your the SP
Name and it's code :)
HTH
--
Stephen Russell
Sr. Production Systems Programmer
First Horizon Bank
Memphis TN
901.246-0159
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
