Hello,

I ran into this issue when an uncommitted transaction caused the error message. Manually committing the transaction solved the error. Please consider using DBCC OPENTRAN to identify open transactions that may need to be committed, or as a last resort, killed.

I hope this is helpful!

DBCC OPENTRAN -- https://msdn.microsoft.com/en-us/library/ms182792.aspx

COMMIT TRANSACTION -- https://msdn.microsoft.com/en-us/library/ms190295.aspx

Additional Research -- http://www.dotnetlearners.com/blogs/view/3/MS-SQL-Query-to-find-and-remove-uncommitted-or-open-transactions.aspx