Activity overview
Latest activity by Thilo_Muehlberger
A Solution: 1. Close SSMS 2. Open the latest SQL Prompt log file in %localappdata%\Red Gate\Logs\SQL Prompt 10 and search for the error message "database is locked" Sample result is as follows: code = Busy (5), message = System.Data.SQLite.SQLiteException (0x800007AF): database is locked database is locked at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at RedGate.SqlPrompt.TabHistory.DocumentStore.MarkDocumentOpen(Int64 documentId) at RedGate.SqlPrompt.TabHistory.Monitoring.TabWatcher.<>c__DisplayClass14_0.<OnDocumentOpened>b__0() at RedGate.SqlPrompt.UsageReporting.ErrorReporting.ErrorReporterWithUI.Do(Action action) Result: it is verified that the error has something to do with SQL Prompt 10 due to the error message could be found. It is clear now that the error message was raised by SQLite 3. Move to folder %localappdata%\Red Gate\SQL Prompt 10 There are two SQLite databases, SavedTabs.db and SqlHistory.db 4. Create a backup of each, for example with Ctrl+C, Crt+V of each file Note: a backuped SQLlite file have no locks anymore 5. Delete or rename each of SavedTabs.db and SqlHistory.db 6. Rename the backuped files to SavedTabs.db and SqlHistory.db 7. Start SSMS / comments
A Solution:1. Close SSMS2. Open the latest SQL Prompt log file in %localappdata%\Red Gate\Logs\SQL Prompt 10 and search for the error message "database is locked"Sample result is as follows:code = ...