Go to the client's pc on which they want that setting then go change this (I think it's possible to change that in rgional settings but I'm not 100% sure...

Re-click on watch this topic.  Sometimes that flag gets deleted.  I e-mailed Steve about this and he apparently can't figure this one out (or doesn't have time to anyways).

I know I'm a scare ressource this year, my schedule is busy for the next few months. Almost up to christmas (if you consider the normal week hours at 100)...

Please post the execution plan.  And the table DDL if that has not been posted yet.

What do you do when the user genuinly wants to type in those characters??

I mean the apostrophe in french, and even english, is a pretty common character, ain't it?

Have you tried playing with the regional settings (I never did this so it's just a guess)?

Most importantly, only 10-15 persons monitor this thread VS a few 100 000 monitor new threads.  So odds are on your side when you start a new thread.

So how did this one end up?

Please do not cross-post, we monitor all boards.

Please continue this thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=21&messageid=384983

Why do you want to move the XML?

The parsing technic you are using is fine... an optimal compared to XML.

Th eonly other option is to create a temp table on...

You'd be surprised on this one... you're version forces 5 table scans while the udf takes only one and some overhead to call the function.

The fastest version of this is to...

You need to upload it onto a web server.  AFAIK, there's no working way to do this at the moment.

Jeff, do you suggest to add a line in the open connection such as : SET DATEFORMAT YMD.  So that all incoming connections from now on are certain to have...

Isn't there a varchar(max) in 2005??  I am really asking because I don't know if there's another limit for the dynamic sql length.

Anyhow a couple solutions already exists for this...

Create WorkQueueTable (permanent table)

(

id int

)

then in the trigger, you simply insert the ids in that table

Then you assign a job to run each X minutes or whatever delay you feel...