I think my problem is linked to the linked server DATA ACCESS, if we can get to the bottom of that then it should work as the generate scripts tries to query procs on the distribtion database on the distribution server Although in users and logins i've yet to find the elusive remote login account called distributor_admin under security logins and users.