Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transactional Replication

Status
Not open for further replies.

Andel

Programmer
Feb 15, 2001
366
US
My replication is stuck just because of one command that inserts a record with a null value in a non nullable column.


ERROR:
Must attach a value to the binary prefix '0x'; zero-length binary value is not allowed.


LAST COMMAND:
insert into "credit_card" values (12579487, 1, 1, 0x , '022002', 'Firstname Lastname ', NULL)
Transaction sequence number and command ID of last execution batch are 0x00011A9100014F22001B00000000 and 1.


How can I cleanly clear this last command?

Andel
andelbarroga@hotmail.com
 
Use SP_MSKILL_JOB

See for syntax the online manual.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top