急啊~~~~~~~怎么可以查到Stored Procedure的创建时间?

[gopark]

我刚写的一个Stored Procedure找不到了,名字也忘了,能查到创建时间吗?
我用的是SQL2008....
谢谢了...

[快乐_石头]

select *
from sys.objects 
where type='P'

[htl258_Tony]

select * from sysobjects where xtype='p'

[htl258_Tony]

select name,crdate from sysobjects where xtype='p' order by crdate desc

这个查看过程名和按创建时间倒序排序，自己看看哪个像。

[htl258_Tony]

select name,crdate from sysobjects where xtype='p' order by crdate desc

这个查看过程名和按创建时间倒序排序，自己看看哪个像。

[envykok]

select name,crdate from sysobjects where xtype='p' order by crdate desc