CREATE TABLE dbo.Tally (
   N int NOT NULL PRIMARY KEY CLUSTERED
)

DECLARE @startDate datetime
DECLARE @endDate datetime

SELECT @startDate = '20090215', @endDate = '20090219'

SELECT DATEADD(day, T.N, @StartDate) AS [Date]
FROM dbo.Tally T
WHERE (T.N >= 0 AND T.N <= DATEDIFF(day, @startDate, @endDate))
ORDER BY T.N

DECLARE @StartDate DATETIME;
DECLARE @EndDate DATETIME;

SET @StartDate = '4/1/2012';
SET @EndDate = '6/15/2012';

;WITH
   n AS (SELECT num = ROW_NUMBER() OVER (ORDER BY (SELECT 1)) FROM sys.all_columns a1 CROSS JOIN sys.all_columns a2),
   dt AS (SELECT [date] = DATEADD(day, n.num - 1, @StartDate) FROM n WHERE n.num BETWEEN 1 AND DATEDIFF(day, @StartDate, @EndDate) + 1)
SELECT * FROM dt;