yup, it was the unprintable ASCII 16.

thanks everyone.

seems to be something in next section of file, where unprintable boxes are ASCII 16's.

Stuff between /* ... */ is not SQL, so treat as text rather than trying to...

correction, same as Lowell's post except 'sql' instead of 'txt' as extension.

Not able to post screenshot, sorry.

image wants URL but don't have ability to do that, sorry.

it is same as your screen except `sql` instead of `txt`.

Added this today well after the trouble began.

tried that, but for *.sql extension.

Thanks for trying.

p.s.

supposedly Win XP has some kind of extension default in the Registry, but can't spot it.

when double-click,

they open SSMS ... but the file itself opens in Notepad.

tried suggested link ... no help.

Windows XP Pro v2002, SP3

SSMS 10.0.1600.22

This has been resolved (the hard way). Thanks for suggestions.

unfortunately didn't have much choice in how to make this particular script batch.

Thank you.

Created first file via Windows Explorer -> File -> New -> Text Document,

renamed to trfxLa.SQL,

then copied that to the others which were edited slightly & renamed.

Now wonder if I clicked...

Tried those, they work from DOS command prompt but not when sent via my program.

Seem to be more interactive than scm, e.g. display a message box with OK button.

Is `net`...

:satisfied: Thank you for posting this. Would have wasted half a day due to confusion about which software the SP referred to in @@VERSION.

Your query showed SQL was...

:w00t: fascinating concept.

Which versions of SQL is this intended for? I am getting error from SQL Query Analyzer 2000 when try to execute the trigger section on a db...

Different owners a possibility. How would I find out if that situation exists?