On second thought...attempting to redo replication like that (dropping the DB, then recreating the subscriptions, etc) gives you an error that you can't drop a database when it's being used...

Thanks for the quick response Gail. I am running the CHECKDB and will attach the results (currently at 7.9% and climbing S-L-O-W-L-Y...)

Question to throw your way though...since this database is...

Did you ever find a resolution to this? Since 3:23pm today we're suddenly getting log dumps every 1 minute and it's incredibly confusing perusing through these dump files.

The gist...

Rebooting the server resolved the issue...

I also saw this in the SQL Event Log:

The activated proc '[dbo].[sp_sysmail_activate]' running on queue 'msdb.dbo.ExternalMailQueue' output the following: 'The service queue "ExternalMailQueue" is currently disabled.'

I'd hate to just "restart" as being the end all fix for something I haven't yet figured out the solution to (not to mention the "powers that be" in the...

I don't get it...I can't find any errors in the windows event or SQL logs. Everything says successful. Surely there's an error somewhere???

You're certain the only thing to...

Thanks for the quick reply Lowell...no errors found though...

Had a brain fart there when I posted my comment about the SMTP service...went into look to check on the SMTP service...

Nevermind...found the issue. Apparently it doesn't worky well on SQL 2005, runs great on 2008!!!

:pinch:

Should look something like the attached images...

Again, we want to help...but you've got to provide what we request or it's difficult for anyone to help you out - I've asked for you to send me what...

Send me what you have and I'll send it back. Executing the batch file directly is one option, executing it via a stored proc is another. Both can...

The Excel file (VBA code) would execute an sp, but the sp itself would have to use xp_cmdshell (like you said). But since the connection to the SQL Server/DB...

I've yet to have a positive experience come out of talking with M$ support, typically I've experienced they go through everything you've already tried only to arrive and the same...

Give them an excel spreadsheet with a command button on it, when they press it it calls your routine. Very simple to do easy to lock down with a...