Viewing 15 posts - 1,411 through 1,425 (of 1,583 total)
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 4:01 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 3:40 pm
Rebooting the server resolved the issue...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 11:15 am
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.'
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 10:21 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 10:16 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 9:44 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 30, 2011 at 9:34 am
Nevermind...found the issue. Apparently it doesn't worky well on SQL 2005, runs great on 2008!!!
:pinch:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 28, 2011 at 3:57 pm
Should look something like the attached images...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 28, 2011 at 10:44 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 28, 2011 at 10:26 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 27, 2011 at 8:01 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 26, 2011 at 4:56 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 26, 2011 at 3:04 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 26, 2011 at 2:46 pm
While I agree with Gail (it's already been done), the answers to your questions are...it depends on your system, uptime, SLA, and so forth.
IMHO, you would REORG anything between 10%...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 26, 2011 at 1:18 pm
Viewing 15 posts - 1,411 through 1,425 (of 1,583 total)