Please check any exclusive Deny access on the given table to the specific user.

[font="Tahoma"]Incase you are using local dstribution, please try the below steps,

1. Right click local publicaiton->Distributor properties

2. Select the publisher in the list, click ...

3. In agent connection mode, select "impoersonate...

Try to access the file using xp_cmdshell 'dir \\machineB\Backup' to check whether SQL Server is able to access.

If you are still getting error, try by giving write permission for the...

The trigger ddl_trig_login is trying to insert a row while doing login deletion. Please either delete the trigger or get the permission to select and insert on the table 'sec_UserMail'...

Backup can be taken without any issues.

To restore follow the below steps,

1. Change the publisher database into single user mode.

2. Restore the publisher database

3. Run 'sp_replrestart' against publisher database.

4. Stop...

Please check whether you are connecting SQL Server 2008 from ssms(SQL 2008 client) and not from sqlwb(SQL 2005 Client).

Hi Verma,

"sys.sp_MSdrop_expired_subscription"

stored procedure will be available under mssqlsystemresource database and no need to create it on user databases.