Fortunately yes. The only Subscription that should be there is the only one there. Still having the issues though. Can't drop the article b/c it is still showing to...

Thanks for your reply! Just before I got your reply I tried a feature that I found in BOL. It made life A LOT easier for me. It is...

All,

Now that I have the sp_send_dbmail working, I have tried to incorporate that into a trigger for confirmation info.  I've tested the process in Query Analyzer and it works...

Yes, I set that up last week and it is working fine now, thanks!  A word to the wise however; when you are setting up a profile configuration, don't place...

Curious, are there any known issues with xp_sendmail from just having the SQL Server Standard Edition as opposed to SQL Server Enterprise Edition?

I am getting a different error today:

Msg...

Yes, the distribution DBs are on the same server as the subscriber.  The subscriber server is the one that I will be upgrading to SQL Server 2K5.  Would it be...

Thanks for the reply... We are still having issues with performance but I think that we've narrowed it down to bad data and/or equipment issues at this particular remote site. ...

Interesting...going through EM did the trick.  The log file was successfully reduced. 

The log is backed up on schedule every two hours via a Maint. Plan.  The...

Returned this statement:

Cannot shrink log file 2 (axdb_Log) because all logical log files are in use....

DBCC execution completed. If DBCC printed error messages, contact...

Here is what the DBCC SQLPERF(LOGSPACE) returned.

Database Name  Log Size (MB)  Log Space Used (%)  Status     

-------------  -------------  ------------------  -----------

Production     124251.8       0.18981564          0

I actually read it in another forum.  There was another DBA out there who apparently ran into the same issue.  I looked in Task Manager on the server and there...

All, I found out what it was.  I had a Maintenance Plan that didn't complete a backup that morning and the file was corrupted.  Somehow when the MP didn;t function...