Example data stored (in reality 200 fields)

Pkey OMG NUMV ...

Lowell (6/6/2012)

---

details are in order, i think.

are you really just running 'dir d:\runtime\SomeExec.exe' (directory!) or are you EXECUTING 'd:\runtime\SomeExec.exe'

The 'dir' version just made clear that xp_cmdshell is working

how do you...

Thanks Jan,

I new it was something small and obvious.. 😉

Yes, that would be a partial solution, especially since 90-95% of columns are nullable..

Hi,

We checked TCP/IP settings in Configuration Manager and found out that TCP port for IP All was blank. Settings this to 1433 and using localhost instead of machine_name\instance_name...

Checked this, but it does not seem to be the...

MarkusB (9/2/2009)

---

When you restore a backup of a database to a different server all string columns will keep the collation of the original database. In your case I suspect that...

Never mind.. Forgot the explicit outer select :w00t:

Yes, i understand the mechanism. I was wondering if it works for you as well with the data provided, since your initial reaction was that nothing was returned:-)

That is a bit scary, cause I want to make sure that it will work over at customers.

Would it be too much to ask to try my table download in...

It does exactly what I want ,when I specify the right languagecode.

The following is what I got at the moment:

select temp.id,temp.xmlname.value('(//Translations/Translation[@Language = "1043"])[1]','nvarchar(max)') from

(select id, cast(name as xml) as xmlname from someschema.sometable) temp

Still do not understand why the [1] is needed...

Ahum,

The xml expression itself is stored as a nvarchar(max) type and not as an xml datatype. I guess that means that the xml type of query expressions will not work?

The error received is returned through the BI-tool and is no more then a hint to contact the database administrator.

Tried to replicate the error message this morning , but...

scan table sysobjects for xtype = 'U' and table_name to avoid dropping other objects that may have the same name (accidently)