> -----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 found out that this seems to only return records where the Creation Date meets the criteria, not what I would expect "last altered" i.e. last touched or changed date. As a test I added a new SP and it showed up in the results. I include LAST_ALTERED so could see the timestamp. I waited a bit, changed something in the working code (not just a comment section for example) and the timestamp did not change. Matt Jarvis Programmer/DBA King | Retail Solutions 541-349-8512 Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. _______________________________________________ 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.
