Binaryworld - Get all databse objected created between specified daterange ... [ SQL Server -> Stored Procedure ]

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

EXEC GetObjCreateDate 'pubs', '01/05/2002', '06/05/2002'
*/

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

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