Binaryworld - Get all objects created before a specified date ... [ SQL Server -> Stored Procedure ]

/*
This stored procedure will scan a database for objects created
before the given date and return their names.
You should pass the database name and the date as in the example below
(if the database name was not specified, the current database will be used,
if the @Date was not specified, the current date will be used):

EXEC GetObjCreatedBeforeDate 'pubs', '01/05/1999'
*/

IF OBJECT_ID('GetObjCreatedBeforeDate') IS NOT NULL DROP PROC GetObjCreatedBeforeDate
GO

CREATE PROC GetObjCreatedBeforeDate (
@dbname sysname = null,
@Date datetime = null
)
AS
DECLARE @s varchar(255)
SET NOCOUNT ON
IF @Date IS NULL SELECT @Date = GetDate()
IF @dbname IS NULL SELECT @dbname = DB_NAME()
SELECT @s = 'USE ' + @dbname + ' SELECT name FROM sysobjects WHERE crdate < ''' + CONVERT(varchar(12), @Date, 101) + ''''
EXEC(@s)
GO