I've having issues deprovisioning a sync server. Initially I was deleting all objects in the Sync schema on SQL Server and deleting any stored procs ending in _selectchanges) as these were created in the dbo schema.
I thought this was working OK but have now found that the source tables have insert/update/delete triggers left on them (in the dbo schema)
When I try to run the SqlSyncScopeDeprovisioning.DeprovisionTemplate method (from MSDN http://msdn.microsoft.com/en-us/library/microsoft.synchronization.data.sqlserver.sqlsyncscopedeprovisioning.deprovisiontemplate(v=sql.110).aspx)
I get an error that the server is not provisioned for sync
Full Error:The current operation could not be completed because the database is not provisioned for sync or you not have permissions to the sync configuration tables.
What is going on?? Has anyone successfully fully deprovisioned their server?
