This might be better, otherwise there's an implicit 00:00:00 for the time portion:

select * from projects where startdate between '03/01/2006' and '03/31/2006 23:59:59' OR enddate between '03/01/2006' and '03/31/2006 23:59:59'

For #2, another way is:

select * from projects

 where (DATEPART(year, startdate) = 2005 and DATEPART(month, startdate) = 5 )

 or (DATEPART(year, enddate) = 2005 and DATEPART(month, enddate) = 5)

I don't really understand your problem, but I had "timeout" errors with transactional replication when initializing large snapshots. To fix my problem, I changed the distribution agent to use a...

Now you'll have to explain "set based solution"   !!   🙂

==============

where can i find "Whenever the job completes" option? BTW, i am using sql 2000, standard edition.

==============

In Enterprise Manager, expand "Management" >> "SQL Server Agent" >> "Jobs"   Find the...

That's good for Maint plans, but what about all the other SQL jobs ?   I have a procedure to write ALL jobs to a table, then I can run a script...

Not quite clear ...   Your trying to restore master from where to where ?

You probably don't neet to restore Master to your new machine.  If it's a new installation of...

I assume you have "Whenever the job completes" selected ?  The default is "When the job fails".  Is the job running under some low level owner ??  (wild stab in...

Does the test actually send an email successfully !!

To quickly setup backups, use the Maint Plan wizard to generate regular DB and Log backups.  I think the Maint Plan won't let you specify a drive on another server,...

I think this was caused by me accidentally creating the subscription as an anonymous pull subscription. I dropped it & created it as a named pull subscription and now it...

Sorry ........  I "deleted" the data, not truncated

Thanks for all the great replies.  Our "WhatsUp" product does monitor free space, so I've asked my network admin to set it up a few specific instances.  I'm going to...

The reason I ask is that I was copying data from a bunch of tables in one DB to another DB. Some of the tables had relationships to each other, so...

Well that looks pretty simple in comparison, but is it only for Merge Replication ?    BOL says: "Changes some merge filter properties. The merge filter properties that can be changed...