Modified Proc

daveL

How Can i Find the last Modified date of a Proc

Thanks DaveL

Aug 31 '08 #1

Erland Sommarskog

daveL (ve***********@yahoo.com) writes:

How Can i Find the last Modified date of a Proc

If you are on SQL 2000, you can't. If you are on SQL 2005, it's in
sys.objects.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Aug 31 '08 #2

daveL

thank you much
DaveL

"Erland Sommarskog" <es****@sommarskog.sewrote in message
news:Xn*********************@127.0.0.1...

daveL (ve***********@yahoo.com) writes:

>How Can i Find the last Modified date of a Proc

If you are on SQL 2000, you can't. If you are on SQL 2005, it's in
sys.objects.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Aug 31 '08 #3