Replication problem

  • I am trying to set up replication ontwo servers and I'm gettin an error

    515 cannot insert the nul value into column 'step_name', table 'msdb.dbo.sysjobsteps'; column does not allow nulls.  insert failed

     

    the problem is i'm using the replication wizard.  anyone know how to fix this prob

    James



    SQL Developer
    James
    Access Accounting Ltd

  • Do you have a package with a nameless step??

  • no  not to my knowledge

     



    SQL Developer
    James
    Access Accounting Ltd

  • Hmm, try runing the profiler to see what the wizard is doing... you should be able to trace the problem from there.

  • I'll give it a go thanx

     



    SQL Developer
    James
    Access Accounting Ltd

  • Some more detail perhaps ?   This occurs while creating the publication or subscription ?  At what point in the process ??   What type of replication ?  

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply