Thank you both very much 🙂

Found a solution, if you do the  AND part first sql seems to like it. And you get the result set you would expect.

This....

let $transaction := $b/Transaction[TransactionStatus...

Tried workaround 1 but it didn't work for me, but workaround 2 did. I set the path to DLL in SSMS

To

‘C:\Microsoft SQL Server Migration Assistant for Oracle Extension Pack\bin\ext\x64\SSMA4OracleSQLServerExtensions.dll’.

I then...

FYI its a bug with SSMA

I apologize for any inconvenience and it seems like either the environment variable of SSMA path is incorrect, or the installation of extension pack writes...

The working sql 2008 standard edition env is a VM not attached to a domain.

The 2012 developer edition is a local install on by client machine. Even if I use...

PS the query itself works fine on 2012 developer

select name,convert(char(20), sysdatetime(),120) from [master].[sys].[servers] where server_id = 0

PC028132015-08-07 18:00:20

That's awesome , thanks for that , that makes sense.

Thank you so much 🙂