Here are some simple steps that can help you resolve your Microsoft SQL Server error 1205 issue. Error 1205: The transaction (process id) was stuck on resources with the main…