Brilliant - never noticed that little SSMS 'feature' before! Well that's got my "command" where i want it.

Needless to say it runs fine from the SSMS window using 'exec' but the replication still fails on update.

Any thoughts where to go next? Nothing much in Googleland

Command attempted:

{CALL "sp_MSupd_BULLPERSON" (62,'Mr','FRANK','Q','SPENCER',123456,NULL,'270944','M','1939-09-13 00:00:00','M',NULL,NULL,NULL,NULL,'2013-01-18 14:10:36',NULL,NULL,NULL,NULL,NULL,'

(Transaction sequence number: 0x0000000000000000000700000000, Command ID: 2)

Error messages:

Invalid distribution command, state 2: transaction 0x0x0000000000000000000700000000 command 2{offset : 175 token offset: 174 state: 50) }. (Source: MSSQL_REPL, Error number: MSSQL_REPL21001)

Get help: http://help/MSSQL_REPL21001