On Fri, Feb 13, 2009 at 9:46 AM, Matt Jarvis <[email protected]> wrote:
>> -----Original Message-----
>> From: [email protected]
> [mailto:[email protected]]
>> On Behalf Of Stephen Russell
>> Sent: Thursday, February 12, 2009 1:25 PM
>> To: [email protected]
>> Subject: Re: [NF] Asking SQL Server 2K about last modification date
> <snip>
>>
>> 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 :)
>>
------------------------------
I went to the table with code. Drats that was not kept upto date.
SELECT * --name, create_date, modify_date
FROM sysobjects
WHERE type = 'P'
AND refdate >= dateadd(d, -15, GETDATE())
ORDER BY refdate desc
This will work in 2000 to get you the real timestamps on the object,
and it's name.
--
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.
