N/APosted on - 02/18/2012
I used the Configure Distribution Wizard in my MS SQL Server 2005 to setup its distributor.
However, I end up with this error box. How to get rid of this and what is the possible fix?
Detach database failed for Server 'Instance Name'. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch.
Cannot execute 'sp_updatestats' because the database is in read-only access mode.
Cannot DETACH a database snapshot. (Microsoft SQL Server, Error: 15635)
Error 15635 on using Configure Distribution Wizard in MS SQL
The error and cause is very simple because the error came out and tell you already what is the cause because when you tried to detach a database snapshot on your SQL server, it is just saying to you that you cannot attach or detach database snapshots on the SQL
So please avoid doing that because it is not allowed by the system, because this is because of the privacy of the database that is why it is not allowed so please understand that they created SQL to protect its databases. But there are other ways to do your snapshots. Have a great day and enjoy your stay