Re: Last Saved/modified date of Stored Procedures

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/06/04 

Date: Tue, 06 Apr 2004 12:27:37 -0600

And in addition, no stored procedures aren't saved as files
on the hard drive - not unless you write scripts for the
stored procedures modifications and save those (which isn't
necessarily a bad idea). But SQL Server doesn't do anything
like that "behind the scenes".
If you want a new create date every time you modify a stored
procedure, you need to do a drop procedure and create
procedure instead of an alter procedure.

-Sue

On Tue, 6 Apr 2004 12:24:27 -0400, "J Baird"
<jill[dot]baird[at]lmco[dot]com> wrote:

>I'm not sure if this is the right newsgroup for this, but I took a guess...
>
>Is there any way to find the "Last Saved Date" or "Last Modified Date" for a
>SQL Stored Procedure? I have only found "Create Date" in SQL Enterprise
>Manager.
>
>Are Stored Procedures ever saved as files on the hard drive? If they are,
>then maybe I could find the last saved date using Windows Explorer on the
>SQL Server.
>
>Any ideas for finding the Stored Procedure "Lst Saved Date", that don't
>involve installing any software (that's not an option in this case)?
>

Relevant Pages

  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Securing Stored Procedures from being seen
    ... username, but in SQL Server, there are too many users to map an individuals ... granting the group execute permissions. ... but I would have to know what groups the user belongs ... see the names of any stored procedures to which he has no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7
    ... For parsing a string to a date/time, the 103 format doesn't limits the user ... > which is used as the row source for the results form). ... > other solutions assuming I have to use SQL Server 7? ... > I don't understand how I can use parameterized stored procedures to solve ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Limiting views on data in a table
    ... returns the Windows login the user uses to connect to SQL Server. ... > The way I was implementing this was to use Windows Auth with a Windows ... > covered by which salespeople, ... > with it via the stored procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: Help understanding Stored proc Level Secuirty?
    ... Jasper Smith (SQL Server MVP) ... I set permissions to my Stored Procedures, ... Access to stored procs fail ...
    (microsoft.public.sqlserver.security)