Let me weigh in with the observation that the 1 and 0 should be reversed on 3rd answer. [which by the way I determined before reading the comments.] Interesting exercise.

Sorry, I seem to have misdiagnosed the problem. The permissions were not staying when set in the subscriber database. I deleted all tables and recreated them, setting the permissions with script...

Thank you Aaron & David; I'm expermenting with both suggestions. My boss also suggested that since the text was growing so large we could just display it as a PDF...

Appreciate the response.

We don't use Cold Fusion. Intend to install SP3 when operational commitments allow.

The Blackbox trace we're running hasn't given any useful data; it actually is reporting "Failed...

Allen

I'm not much of a Performance Monitor user but when I set up the four counters you recommended they all read out at 100% [or 0 but I only see...

No other applications. I will set up the performance monitor.

Thanks

Bob

quote:

---

Are there any other applications also running in this server? Keep watching...

I ran xp_fixeddrives on 3 servers; the problem box and another production server. No error on either and the xpstar.dll version is the same. Also no error on my development...

Thanks Allen & Robert

Here are the other errors and interesting lines in the SQL Server Logs:

Operating system error 1: Incorrect function...

Error: 17059, Severity: 18, State: 0

Error 17882 ... [subject error]

Error:...

In continuing to troubleshoot this problem I came upon the Remote Servers tab under Security in EM which had an entry. I deleted that entry and was warned that a...

Again appreciate the response.

Mkumari - The SQL Agent login is in the local Admin group.

jmadren - I've tried both the "Configure Publishing, Subscribers, and Distribution..." wizard and "Create and...

quote:

---

I am sorry, I mean How you are starting the SQL Agent services.

---

SQLServer and...