I have setup a replication publication and subscription on a server and it runs fine at the moment for any table changes and data changes in the tables. I have gone onto the other server and i can see the changes have come across. However changes to a stored procedure (i have a filter so only one is selected for now) are not coming over the new server.
Can anyone help with why a change to a stored procedure is not copying over? I have used the transactional replication option.