Re: Modified datetime of Stored Procedure in SQL 7.0

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 09/04/03


Date: Thu, 4 Sep 2003 08:01:25 -0400


Unfortunately there is not. Unless the sp was dropped and recreated you
can't tell if was altered with an ALTER PROC statement.

-- 
Andrew J. Kelly
SQL Server MVP
"Mustaq" <mustaqhussain@hotmail.com> wrote in message
news:172a01c372ba$eafa6db0$a501280a@phx.gbl...
> Hi
>
> By anyway can I get the modified datetime of Stored
> Procedure in MS SQL Server 7.0
>
> Regards,
> mustaq


Relevant Pages

  • Re: Determine Disk Block Size ?
    ... As always, thanks Andrew. ... Most of the documentation for 2000 is wrong in that it may state you need multiple files to spawn multiple threads. ... >> The MS SQL Server Operations Manual makes a recommendation of using 64-KB>> cluster sizes. ... We have done so with a dramatic total disk I/O>> throughput. ...
    (microsoft.public.sqlserver.server)
  • Re: different environment fails to fill a dataset
    ... Well I recreated the login but it didn't make any difference. ... Andrew J. Kelly SQL MVP ... Is there anything in the environment or SQL Server that could be ...
    (microsoft.public.sqlserver.clients)
  • Re: different environment fails to fill a dataset
    ... successfully ran the select command with no problems. ... Andrew J. Kelly SQL MVP ... Is there anything in the environment or SQL Server that could be ...
    (microsoft.public.sqlserver.clients)
  • Re: High availability
    ... I agree with Andrew. ... Senior Database Administrator ... Microsoft SQL Server MVP ... Both scaling up and>>> out ...
    (microsoft.public.sqlserver.clustering)
  • Re: High availability
    ... Thanks Geoff and Andrew for the good info, I guess my best bet is to scale up ... setting up sql server failover clustering, replication, High availability, ... Senior Database Administrator ...
    (microsoft.public.sqlserver.clustering)

Quantcast