How to split tables without affecting all stored procedures
I may be missing something, but instead of splitting tables, have you considered parameterized filters?


  Parameterized filters allow different partitions of data to be sent to
  different Subscribers without requiring multiple publications to be
  created. For example, a table can be filtered so that data for a given
  sales representative is replicated only to that representative.
  Parameterized filters have a variety of options that allow you to
  tailor filtering to optimize performance and best match your data and
  application requirements. For more information, see Parameterized Row
  Filters.