I just ran into a small 'oops' moment just now.
While the RTM version of NAV2013 is release last week, I decided to updat my client from the beta version to the RTM version.
This is what happened:
This is wher everything halted with the message that the database had to be converted. Ok, this is no problem in this case. But when I clicked 'OK', I got the error that the database could nog be converted because there were objects locked in de database. Off course this was a beginners mistake but how to correct it without uninstalling the RTM and re-installing the beta client, unlocking the objects.. etc?
If you run into this problem, this is one solution:
Open your SQL Server Management Studio and input the following query in while connected to the correct SQL instance. (Replace "Demo Database NAV (7-0)" with your own database name)
UPDATE [Demo Database NAV (7-0)].[dbo].[Object] SET [Locked] = 0 ,[Locked By] = '' WHERE [Locked] = 1 GO
Run the query and close your SQL Server Management Studio before retrying the conversion!
It's just one of those mondays...
what happen if you just detach beta database and attach new RTM database in sql server?