How do you subscribe to QOD ?

I'm undecided ......  I was going to go, but our company's in "cost saving" mode .... so I thought I'd do my part & skip it

Remi,  you're a first year programmer, with 4400 posts !!      You've had some pretty good ones, so you must be picking this stuff up pretty quickly !   Time to ask...

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