SQL - -SYSTEM LOCK ERROR-What to do if system SFT Lock Appears

Issue:

Unable to move product through Shop Floor Tracking due to the following message:
 
 

   

 

Resolution:  There is a SFT_lock.sql attached below and/or there is a stored procedure sp_unlockSFTFlag as part of the database.   Go into the SQL Server Management and run the attached script, this will remove the SFT Lock placed on your tables.

Reason: User will receive this message after one of the workstations that was in the process of moving product through Shop Floor Tracking had experienced lost connection to the Network, or their workstation had actually crashed.The system will then place this lock on the table to prevent any possible corruption. 

Prevention: If users see a message that the file is currently in use have them wait a few minutes and try again, not to Clt+Alt+Delete out of the system.