Select Records between two dates in SQL Server

declare @Schedules table (Name varchar(20), [Schedule] DateTime)

insert into @Schedules
select 'Schedule1', '2012-09-03 16:15:15.307'
union all
select 'Schedule2', '2012-08-15 16:14:15.307'
union all
select 'Schedule3', '2012-11-03 16:15:15.307'

select * from @Schedules
where [Schedule] between  '2012-08-03 16:15:00' and  '2012-09-03 16:16:00'