Hi,

If you create your ActiveX script to move the file you should then be able to create the failure workflow between the destination of the transform task and the script...

Vivien - Thanks for the link, I hadn't heard about this. Everyday's a school day!

To everybody, the support and info is great. Thank you all. 😀

To forget the punchline makes the guy a comedy criminal...

But to forget that punchline in front of his wife...

Classic 😀

...Tell me about it, I'm surprised I don't get taxed for posting on forums (maybe just a matter of time!)...

Thanks for your help guys... One huge bonus of moving to Vancouver is that when the PASS conference hits Seattle again, I'll actually be able to go!! 😀

Thanks for you reply. I've looked in to the immigration policies etc, and I'm putting some feelers out for job opportunites and generally just trying to get some info from...

I think something like this should work.....

Declare @x xml;

With XMLNAMESPACES ('http://www.test.namespace.com/ns/1.0' as c)

SELECT @x = 'value' [c:test] For xml path(''),Elements, type

Select @x

I'd go with Father Christmas as it sounds like you job is to bring hope, joy and the gift of working systems to the entire business. 😀

My 2p: I'd go...

I think this KB article from Microsoft will help:

http://support.microsoft.com/kb/904796

Si,

You make a burnt out 1993 Vauxhall Nova 1.3 rotting by the side of a main road for six months sound so dull! :crazy:

They are cool pictures though. The Golden...

I haven't touched sybase for a while but I think it'd be something like:

SELECT {columns}

FROM sysusages, sysdevices

WHERE sysusages.vstart >= sysdevices.low

AND sysusages.vstart <= sysdevices.high

I think :crazy:

{edit: forgot the 's' on usages!}

They did indeed marry twice, but not so that the marriages were concurrent... Now that's scandal! :hehe:

Is it a simple case of SQL Server Execute permissions? Are you using Windows security on your SQL server and logging in on the other workstation with different credentials? :crazy:

Hi,

What a great app!! Poor you... :crazy:

Try this:

SELECT {all fields except 3 mentioned}

FROM entity_audit

GROUP BY {all fields except 3 mentioned}

HAVING COUNT(DISTINCT entity_audit.changetype) > 1

This should display all of the "saved...

Hi,

Can I ask why would you want to return every one of the 500,000+ changes so far to a database table? Would you not just want to see the latest...