mataleao87 (5/30/2015)

---

That was it. Have many more new issues but seems like some progress...

I think it's the folder permission you need to check, not the files within the folder.

Thanks. Currently I'm working with a mix of 2005 & 2008 servers, so extended events won't work on 2005 (I think).

I'll read up on it for the 2008 servers, as...

Could you elaborate on "Extended events work much better." ??

I came across this bug earlier today and did fix the code. But I was puzzled about why it failed.

I hadn't really though about this:

" the case statement can only...

Thanks for all the feedback.

TORN PAGE is on.

Select * from msdb.dbo.suspect_pages gives 0 results

I have not run CHECKDB for a long time, until the results posted above.

I can run it from a scheduled job without problem, and I can run it manually from a query window without a problem. But when the web application is...

Does anyone have any ideas of how I can troubleshoot this ?

Is there some other error trapping I can do to get a better explanation or more useful error messages...

Can you take a Differential ? If so, at least you will have some protection with the Full that did work, plus a new diff. If it...

Server is running SQL 2005, so please post any replies in a new thread I created in the 2005 forum:

http://www.sqlservercentral.com/Forums/Topic1656437-146-1.aspx

In my recent case, OPENQUERY is better because when...

LutzM (1/28/2015)

---

Did you try use OPENQUERY to force the ORDER BY being performed at the MySQL side before transferring the data?

What happens if you run that query directly at the...

Someone on a MySQL forun feels confident it's not MySQl causing the problem, but rather a bottle neck in the ODBC DSN configuration ...

Thoughts on that ??

Thanks for the replies. I log on to the servers under my own account, so there is a "Reboot Now" button, but I would be the only one to see...