Ok, I'm guessing a little, but do you by chance have this query wrapped inside an EXEC or a sp_executesql? The reason I ask is that when you are...

I see several mentioning martial arts stuff... Do your coworkers have to attend as well to get the full relaxing effect...? 😀

Chad

Excellent idea!

Alright, back to the shadows behind the watercooler for me...

Chad

Do I get a certificate of accomplishment for helping Lynn? Stuff like that doesn't happen every day and I'd like to have something to hang up on my wall....

Wow... it actually worked?!?!

I can't claim credit for the settings - I copied them from a website/blog/forum somewhere I can't now find and luckly it worked for me. ...

Lynn Pettis (1/20/2010)

---

Have to ask, are you running SQL Server 2005 x64 or SQL Server 2005 x32? If you got the linked server to work using the x64 MySQL...

Lynn Pettis (1/19/2010)

---

Totally different subject UNRELATED to questions getting worse. Last week I started working on setting up linked servers on our new blade servers (x64) under SQL Server...

Correction - looking back at the log we did just do a service restart. Of course, that was after 30 minutes of "OH NO!" detective work.

Chad

I'd suggest a reboot/restart as well. We lost connectivity to the SAN during a network upgrade and the database server wasn't shutdown first. The drive came back ok...

Are you really really sure Datum is a datetime field and not a char or varchar field?

Any chance you are using SQL Server 2008 and not SQL2000 or SQL7 and...

Cool - that is good news. I would think that means that the linked server and DTC are working. If the linked server wasn't working, the SP wouldn't...

Yes, that would be the problem. I'm not sure how you got that value into a datetime field though. When I run this script:

DECLARE @Datum Datetime

SELECT @Datum =...

what are the min and max values stored in the column?

Is there anything else done outside the code you posted that might be causing the error (if you run the...

Would it work to use bitwise operators instead? It might be a little easier to add new items later:

DECLARE @OptionSum int

DECLARE @strFinalWhere varchar(max)

SELECT @OptionSum = 12

, @strFinalWhere = ''

--You're...

Is Datum a date field? What are the min/max values in the field?

This might take some work, but here's how you might narrow down which record is causing the...