does this purge only help when using the GUI to execute backups?  (i.e., is there any speed advantage when backups are run from script?).  What else is this likely to...

I was also to delete the failed jobs by doing the following update:

update msdb.dbo.sysjobs set originating_server = 'DATA23' where originating_server = 'DATA2'

at least this got things cleaned up... now, I...

The restarts weren't required just to change the job names back... and since there were all broken, I just changed them back and deleted them (after scripting them, just in...

Good answer Philip Yale!!!

Like I said... Modern OS, Modern DB...

That frequent job is something to be concerned with perhaps.

I'm with Ninja... not going to lose any sleep

Look at your jobs... I have only seen that when one of them is failing.  The failure there may tell you more about what to do.

Okay, so you cross posted and people are helping you there...

Let's close this thread now.

I have had a LOT of problems (issues) with network drives.  The privilege associated with the command is of the user that starts the service - NOT the user who...

you know, even with the file "overwritten"... if you STOP what you are doing IMMEDIATELY and stop ALL other activity on the box, you MAY have been able to "undelete"...

My position with replication (SQL Server, Oracle and Sybase) is to use the "built-in" tools and not even consider the 3rd party products.  But I take this position on most...

nobody has answered and you must be in a panic.

How do you know that inserts and updates aren't working?  Are you getting any sort of a message?  Have you looked...

Is American Idol on again?  Geez!  I MUST get a life... didn't know it was on <sniff>

<sigh>

is the Access application connecting to the correct database initially?  or is there the possibility that it is going through a series of try's to login before it gets to...

but beware of that leading %... causes full scan of table.

very nice!  thanks!

If I may make a couple of suggestions...

1) add some comments...

-- Execute in SQL Query Analyzer

-- Be sure to "use <dbname>" before running

-- Save As <filename>.html

-- Written by...

Is the other DB (the new subscriber) set up in mixed mode? (i.e., to use mixed mode authentication).