Sql Server Programming :: Modification time pf stored procedures


	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... - Hide quoted text - > Hi, > is there a possibility to display the last modification date of all stored > procedures from a database (sorted desc)? > Thanks, SQL 2005 - Hide quoted text - "vt" wrote: > 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... > > Hi, > > is there a possibility to display the last modification date of all stored > > procedures from a database (sorted desc)? > > Thanks, I am using SQL2005 - Hide quoted text - "Xavier" wrote: > Hi, > is there a possibility to display the last modification date of all stored > procedures from a database (sorted desc)? > Thanks, 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... - Hide quoted text - > SQL 2005 > "vt" wrote: >> 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... >> > Hi, >> > is there a possibility to display the last modification date of all >> > stored >> > procedures from a database (sorted desc)? >> > Thanks, 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... - Hide quoted text - >I am using SQL2005 > "Xavier" wrote: >> Hi, >> is there a possibility to display the last modification date of all >> stored >> procedures from a database (sorted desc)? >> Thanks, 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... - Hide quoted text - > 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... >> Hi, >> is there a possibility to display the last modification date of all >> stored >> procedures from a database (sorted desc)? >> Thanks, 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. - Hide quoted text - "Uri Dimant" wrote: > 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... > >I am using SQL2005 > > "Xavier" wrote: > >> Hi, > >> is there a possibility to display the last modification date of all > >> stored > >> procedures from a database (sorted desc)? > >> Thanks, Thanks, Greg - Hide quoted text - "Greg O" wrote: > 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... > > SQL 2005 > > "vt" wrote: > >> 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... > >> > Hi, > >> > is there a possibility to display the last modification date of all > >> > stored > >> > procedures from a database (sorted desc)? > >> > Thanks, 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... - Hide quoted text - > 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. > "Uri Dimant" wrote: >> 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... >> >I am using SQL2005 >> > "Xavier" wrote: >> >> Hi, >> >> is there a possibility to display the last modification date of all >> >> stored >> >> procedures from a database (sorted desc)? >> >> Thanks,