Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Modification time pf stored procedures


Hi,
is there a possibility to display the last modification date of all stored
procedures from a database (sorted desc)?

Thanks,

Hi,

What version of sql you using?

--
VT
Knowledge is power, share it....
http://oneplace4sql.blogspot.com/

"Xavier" <Xav@discussions.microsoft.com> wrote in message

news:4C6931EC-5298-423E-830F-5F247EA12A8C@microsoft.com...

SQL 2005

I am using SQL2005

Hi

try this
    select modify_date from sys.objects where name='objectname'

from BOL

modify_date
Date the object was last modified by using an ALTER statement. If the object
is a table or a view, modify_date also changes when a clustered index on the
table or view is created or altered.

-
Greg O
SQL Server Documentation the easy way
SQL 2000, SQL 2005 the best is back
http://www.geckoware.com.au/Content.aspx?Doc_id=1001

"Xavier" <Xav@discussions.microsoft.com> wrote in message

news:BE6B0018-B0D6-46EB-80D2-F902BA1EF9B3@microsoft.com...

select name,modify_date from sys.procedures

order by modify_date desc

"Xavier" <Xav@discussions.microsoft.com> wrote in message

news:6E4E23E9-55DE-4F4A-A824-DEE94587CB92@microsoft.com...

Hi,

query the sys.objects table
see the following link for more info

http://msdn2.microsoft.com/en-us/library/ms190324.aspx

--
VT
Knowledge is power, share it....
http://oneplace4sql.blogspot.com/

"vt" <vinu.t.1@gmail.com> wrote in message

news:OQMAyD1pHHA.196@TK2MSFTNGP05.phx.gbl...

It works perfect.

How can I get the same information also for the Functions(Table-valued,
Scalar-valued and Agregate Functions?

thanks for your help.

Thanks,
Greg

Hi
Take a look at sys.objects table colum 'type_desc'
select name,modify_date,CASE WHEN

type_desc='SQL_INLINE_TABLE_VALUED_FUNCTION'

THEN 'inline udf' ELSE type_desc END from sys.objects

order by modify_date desc

"Xavier" <Xav@discussions.microsoft.com> wrote in message

news:6BEF4DA0-EC53-4B5E-BDEE-39A87337CB9C@microsoft.com...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc