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%...

Sorry Sean, you had posted your reply while I was typing in mine, didn't mean to duplicate the effort! 😉

Can you do something simple like this or am I missing the boat on this one?

CREATE TABLE #temp (OrderBy varchar(1), OrderDate datetime, OrderCity varchar(15))

GO

INSERT INTO #temp (OrderBy ,...

That's a great point...I've come across this many times in our environment. Quite often we'll have an index that was created ages ago for a report that's no longer...

I still receive the same error. From my research it would appear that by design MSSQL doesn't allow nested transactions across servers. Not 100% certain that's what I...

Yes, they are all set up exactly the same (only differences are hardware).

I checked out the artilcle and will see if that helps, appreciate the input...

Are you running 32 or 64 bit?

We create a system-level ODBC on the server (using the appropriate driver of course - in our case it's the DATADIRECT 4.0 32-bit...

If you have space available on the server you're performing this on, sometimes it's easier to simply create a new table, select the data that you want to keep into...

Well said Masakatsu!!!

😉

?

It will accomplish exactly what you're asking for:

1. send yourself an alert as to how much is free and (how much is used on each drive - Max space -...

Thanks, I'll have to check that...

I found an article on an MSDN blog that said something along the lines of the mySQL DLL receives a PAGE ACCESS VIOLATION and craps...

Check with your IT / Tech Services department to make sure there's been no recent changes to the Exchange Server (assuming your company uses that), there's this nifty little setting...

Did you ever get a reply on this or find a solution?

I am experiencing a similar problem. We have a report that selects from an OPENQUERY to a mySQL...

This is kind of crude code but works well and will email you every few minutes depending on how you schedule the Agent job. Create a job with this...

DECLARE @Param1 varchar(50)

SET @Param1 = (SELECT ReportName from #MyTable WHERE This = That)

EXEC MyStoredProc @Param1

?