Search This Blog

Date the object was created

CREATE FUNCTION dbo.ObjCreationDate
( @objname sysname)
RETURNS datetime
AS
BEGIN
DECLARE @crdate datetime
SELECT @crdate = crdate FROM sysobjects WHERE name = @objname
RETURN ( @crdate )
END
GO

No comments: