I'm getting the following error when initializing a merge replication subscription:
Source: Microsoft SQL Native Client
Message: Could not find stored procedure 'sys.sp_MScreate_tempgenhistorytable'.
Both publisher and subscriber are version 9.0.4053
Scripted the missing proc from publisher and ran create proc (using sa credentials) on subscriber but I get an error message:
Msg 2760, Level 16, State 1, Procedure sp_MScreate_tempgenhistorytable, Line 45
The specified schema name "sys" either does not exist or you do not have permission to use it.
Kind of stuck right now, any help would be appreciated.
View Complete Post