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...

I think that if you change the filter through Enterprise Manager, then it will flag your publication to genereate a new snapshot, and you'll lose your original data at the...

You could put XP_SENDMAIL after your query and send yourself an email ...

And if you modify it slightly, adding a qty field, then you'll get a count of how many duplicate records there are for each group.

select

  fld1,

  fld2,

  fld3, count(*)...