Check for update in SQL 2005 and 2008 Servers

Thanks vaibhav. However it giving 2 columns as a resultset. One as time and the other as a big query consisiting of create procedure and create function text. Also what I understand is that it is for versions above SQL 2005.