Edit C:\Windows\Microsoft.NET\Framework\v3.5\SQL\EN\SqlPersistenceProviderLogic.sql
??S�E�T� �A�N�S�I�_�N�U�L�L�S� �O�N� � �G�O� � �S�E�T� �Q�U�O�T�E�D�_�I�D�E�N�T�I�F�I�E�R� �O�N� � �G�O� � � � �-�-� � �-�-� �D�e�l�e�t�e�I�n�s�t�a�n�c�e� � �-�-� � �I�F� �E�X�I�S�T�S� �(�S�E�L�E�C�T� �*� �F�R�O�M� �s�y�s�.�o�b�j�e�c�t�s� �W�H�E�R�E� �o�b�j�e�c�t�_�i�d� �=� �O�B�J�E�C�T�_�I�D�(�N�'�[�d�b�o�]�.�[�D�e�l�e�t�e�I�n�s�t�a�n�c�e�]�'�)� �A�N�D� �t�y�p�e� �i�n� �(�N�'�P�'�,� �N�'�P�C�'�)�)� � � �D�R�O�P� �P�R�O�C�E�D�U�R�E� �[�d�b�o�]�.�[�D�e�l�e�t�e�I�n�s�t�a�n�c�e�]� � �G�O� � �C�R�E�A�T�E� �P�R�O�C�E�D�U�R�E� �D�e�l�e�t�e�I�n�s�t�a�n�c�e� � � �@�i�d� �u�n�i�q�u�e�I�d�e�n�t�i�f�i�e�r�,� � � �@�h�o�s�t�I�d� �u�n�i�q�u�e�I�d�e�n�t�i�f�i�e�r�,� � � �@�l�o�c�k�T�i�m�e�o�u�t� �i�n�t�,� � � �@�r�e�s�u�l�t� �i�n�t� �o�u�t�p�u�t� � �A�S� � �B�E�G�I�N� � � �S�E�T� �N�O�C�O�U�N�T� �O�N�;� � � � � �D�E�C�L�A�R�E� �@�n�o�w� �d�a�t�e�t�i�m�e�;� � � �S�E�T� �@�n�o�w� �=� �g�e�t�u�t�c�d�a�t�e�(�)�;� � � � � �D�E�L�E�T�E� �F�R�O�M� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� � � � �W�H�E�R�E� �(�i�d� �=� �@�i�d�)� �A�N�D� �(�(�@�l�o�c�k�T�i�m�e�o�u�t� �<� �0�)� �O�R� �(�(�l�o�c�k�O�w�n�e�r� �=� �@�h�o�s�t�I�d�)� �A�N�D� �(�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �>�=� �@�n�o�w�)�)�)�;� � � � � �I�F� �@�@�r�o�w�c�o�u�n�t� �=� �1� � � � �S�E�T� �@�r�e�s�u�l�t� �=� �0�;� �-�-� �S�u�c�c�e�s�s� � � �E�L�S�E� � � �B�E�G�I�N� � � � �I�F� �E�X�I�S�T�S� �(�S�E�L�E�C�T� �1� �F�R�O�M� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� �W�H�E�R�E� �i�d� �=� �@�i�d�)� � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �2�;� �-�-� �C�o�u�l�d� �n�o�t� �a�c�q�u�i�r�e� �l�o�c�k� � � � �E�L�S�E� � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �1�;� �-�-� �I�n�s�t�a�n�c�e� �n�o�t� �f�o�u�n�d� � � �E�N�D� � �E�N�D� � �G�O� � �G�R�A�N�T� �E�X�E�C�U�T�E� �O�N� �[�d�b�o�]�.�[�D�e�l�e�t�e�I�n�s�t�a�n�c�e�]� �T�O� �p�e�r�s�i�s�t�e�n�c�e�U�s�e�r�s� � �G�O� � � � �-�-� � �-�-� �L�o�a�d�I�n�s�t�a�n�c�e� � �-�-� � �I�F� �E�X�I�S�T�S� �(�S�E�L�E�C�T� �*� �F�R�O�M� �s�y�s�.�o�b�j�e�c�t�s� �W�H�E�R�E� �o�b�j�e�c�t�_�i�d� �=� �O�B�J�E�C�T�_�I�D�(�N�'�[�d�b�o�]�.�[�L�o�a�d�I�n�s�t�a�n�c�e�]�'�)� �A�N�D� �t�y�p�e� �i�n� �(�N�'�P�'�,� �N�'�P�C�'�)�)� � � �D�R�O�P� �P�R�O�C�E�D�U�R�E� �[�d�b�o�]�.�[�L�o�a�d�I�n�s�t�a�n�c�e�]� � �G�O� � �C�R�E�A�T�E� �P�R�O�C�E�D�U�R�E� �L�o�a�d�I�n�s�t�a�n�c�e� � � �@�i�d� �u�n�i�q�u�e�i�d�e�n�t�i�f�i�e�r�,� � � �@�l�o�c�k�I�n�s�t�a�n�c�e� �b�i�t�,� � � �@�h�o�s�t�I�d� �u�n�i�q�u�e�i�d�e�n�t�i�f�i�e�r�,� � � �@�l�o�c�k�T�i�m�e�o�u�t� �i�n�t�,� � � �@�r�e�s�u�l�t� �i�n�t� �o�u�t�p�u�t� � �A�S� � �B�E�G�I�N� � � �S�E�T� �N�O�C�O�U�N�T� �O�N�;� � � � � �S�E�T� �T�R�A�N�S�A�C�T�I�O�N� �I�S�O�L�A�T�I�O�N� �L�E�V�E�L� �R�E�A�D� �C�O�M�M�I�T�T�E�D�;� � � � � �D�E�C�L�A�R�E� �@�c�r�e�a�t�e�d�T�r�a�n�s�a�c�t�i�o�n� �b�i�t�;� � � � � � �D�E�C�L�A�R�E� �@�n�o�w� �d�a�t�e�t�i�m�e�,� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �d�a�t�e�t�i�m�e�;� � � �S�E�T� �@�n�o�w� �=� �g�e�t�u�t�c�d�a�t�e�(�)�;� � � �S�E�T� �@�r�e�s�u�l�t� �=� �0�;� � � � � �I�F� �(�@�l�o�c�k�T�i�m�e�o�u�t� �<� �0�)� �O�R� �(�@�l�o�c�k�I�n�s�t�a�n�c�e� �=� �'�F�A�L�S�E�'�)� � � �B�E�G�I�N� � � � �S�E�L�E�C�T� � � � � � �'�i�n�s�t�a�n�c�e�'� �=� �i�n�s�t�a�n�c�e�,� � � � � �'�i�n�s�t�a�n�c�e�X�m�l�'� �=� �i�n�s�t�a�n�c�e�X�m�l�,� � � � � �'�i�s�X�m�l�'� �=� �C�A�S�E� � � � � � �W�H�E�N� �i�n�s�t�a�n�c�e�X�m�l� �i�s� �N�O�T� �N�U�L�L� �T�H�E�N� �1� � � � � � �E�L�S�E� �0� � � � � �E�N�D� � � � � �F�R�O�M� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� � � � � �W�H�E�R�E� �i�d� �=� �@�i�d�;� � � � � � �I�F� �@�@�r�o�w�c�o�u�n�t� �=� �0� � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �1�;� �-�-� �I�n�s�t�a�n�c�e� �n�o�t� �f�o�u�n�d� � � �E�N�D� � � �E�L�S�E� � � �B�E�G�I�N� � � � �I�F� �@�l�o�c�k�T�i�m�e�o�u�t� �=� �0� � � � � �S�E�T� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �=� �'�9�9�9�9�-�1�2�-�3�1�T�2�3�:�5�9�:�5�9�'�;� � � � �E�L�S�E� � � � � � �S�E�T� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �=� �d�a�t�e�a�d�d�(�s�e�c�o�n�d�,� �@�l�o�c�k�T�i�m�e�o�u�t�,� �@�n�o�w�)�;� � � � � � �I�F� �@�@�t�r�a�n�c�o�u�n�t� �=� �0� � � � �B�E�G�I�N� � � � � �S�E�T� �@�c�r�e�a�t�e�d�T�r�a�n�s�a�c�t�i�o�n� �=� �'�T�R�U�E�'�;� � � � � �B�E�G�I�N� �T�R�A�N�S�A�C�T�I�O�N�;� � � � �E�N�D� � � � � � �U�P�D�A�T�E� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� �S�E�T� � � � � �l�o�c�k�O�w�n�e�r� �=� �@�h�o�s�t�I�d�,� � � � � �l�o�c�k�E�x�p�i�r�a�t�i�o�n� �=� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� � � � � �W�H�E�R�E� �(�i�d� �=� �@�i�d�)� �A�N�D� �(�(�l�o�c�k�O�w�n�e�r� �i�s� �N�U�L�L�)� �O�R� �(�l�o�c�k�O�w�n�e�r� �=� �@�h�o�s�t�I�d�)� �O�R� �(�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �<� �@�n�o�w�)�)�;� � � � � � �I�F� �@�@�r�o�w�c�o�u�n�t� �=� �1� � � � �B�E�G�I�N� � � � � �S�E�L�E�C�T� � � � � � � �i�n�s�t�a�n�c�e�,� � � � � � �i�n�s�t�a�n�c�e�X�m�l�,� � � � � � �'�i�s�X�m�l�'� �=� �C�A�S�E� � � � � � � �W�H�E�N� �i�n�s�t�a�n�c�e�X�m�l� �i�s� �N�O�T� �N�U�L�L� �T�H�E�N� �1� � � � � � � �E�L�S�E� �0� � � � � � �E�N�D� � � � � � �F�R�O�M� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� � � � � � �W�H�E�R�E� �i�d� �=� �@�i�d�;� � � � � � � �I�F� �@�@�e�r�r�o�r� �<�>� �0� � � � � �B�E�G�I�N� � � � � � �R�O�L�L�B�A�C�K� �T�R�A�N�S�A�C�T�I�O�N� � � � � � �R�E�T�U�R�N� � � � � �E�N�D� � � � �E�N�D� � � � �E�L�S�E� � � � �B�E�G�I�N� � � � � � �I�F� �E�X�I�S�T�S� �(�S�E�L�E�C�T� �1� �F�R�O�M� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� �W�H�E�R�E� �i�d� �=� �@�i�d�)� � � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �2�;� �-�-� �C�o�u�l�d� �n�o�t� �a�c�q�u�i�r�e� �l�o�c�k� � � � � �E�L�S�E� � � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �1�;� �-�-� �I�n�s�t�a�n�c�e� �n�o�t� �f�o�u�n�d� � � � �E�N�D� � � � � � �I�F� �@�c�r�e�a�t�e�d�T�r�a�n�s�a�c�t�i�o�n� �=� �'�T�R�U�E�'� � � � � �C�O�M�M�I�T� �T�R�A�N�S�A�C�T�I�O�N� � � �E�N�D� � �E�N�D� � �G�O� � �G�R�A�N�T� �E�X�E�C�U�T�E� �O�N� �[�d�b�o�]�.�[�L�o�a�d�I�n�s�t�a�n�c�e�]� �T�O� �p�e�r�s�i�s�t�e�n�c�e�U�s�e�r�s� � �G�O� � � � �-�-� � �-�-� �I�n�s�e�r�t�I�n�s�t�a�n�c�e� � �-�-� � �I�F� �E�X�I�S�T�S� �(�S�E�L�E�C�T� �*� �F�R�O�M� �s�y�s�.�o�b�j�e�c�t�s� �W�H�E�R�E� �o�b�j�e�c�t�_�i�d� �=� �O�B�J�E�C�T�_�I�D�(�N�'�[�d�b�o�]�.�[�I�n�s�e�r�t�I�n�s�t�a�n�c�e�]�'�)� �A�N�D� �t�y�p�e� �i�n� �(�N�'�P�'�,� �N�'�P�C�'�)�)� � � �D�R�O�P� �P�R�O�C�E�D�U�R�E� �[�d�b�o�]�.�[�I�n�s�e�r�t�I�n�s�t�a�n�c�e�]� � �G�O� � �C�R�E�A�T�E� �P�R�O�C�E�D�U�R�E� �I�n�s�e�r�t�I�n�s�t�a�n�c�e� � � �@�i�d� �u�n�i�q�u�e�i�d�e�n�t�i�f�i�e�r�,� � � �@�i�n�s�t�a�n�c�e� �i�m�a�g�e� �=� �N�U�L�L�,� � � �@�i�n�s�t�a�n�c�e�X�m�l� �x�m�l� �=� �N�U�L�L�,� � � �@�u�n�l�o�c�k�I�n�s�t�a�n�c�e� �b�i�t�,� � � �@�h�o�s�t�I�d� �u�n�i�q�u�e�i�d�e�n�t�i�f�i�e�r�,� � � �@�l�o�c�k�T�i�m�e�o�u�t� �i�n�t�,� � � �@�r�e�s�u�l�t� �i�n�t� �O�U�T�P�U�T� � �A�S� � �B�E�G�I�N� � � �S�E�T� �N�O�C�O�U�N�T� �O�N�;� � � � � �S�E�T� �T�R�A�N�S�A�C�T�I�O�N� �I�S�O�L�A�T�I�O�N� �L�E�V�E�L� �R�E�A�D� �C�O�M�M�I�T�T�E�D�;� � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �0�;� � � � � �D�E�C�L�A�R�E� �@�n�o�w� �d�a�t�e�t�i�m�e�,� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �d�a�t�e�t�i�m�e�,� �@�n�e�w�O�w�n�e�r� �u�n�i�q�u�e�i�d�e�n�t�i�f�i�e�r�;� � � �S�E�T� �@�n�o�w� �=� �g�e�t�u�t�c�d�a�t�e�(�)�;� � � � � � �I�F� �@�l�o�c�k�T�i�m�e�o�u�t� �<� �0� �O�R� �@�u�n�l�o�c�k�I�n�s�t�a�n�c�e� �=� �'�T�R�U�E�'� � � �B�E�G�I�N� � � � �S�E�T� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �=� �N�U�L�L�;� � � � �S�E�T� �@�n�e�w�O�w�n�e�r� �=� �N�U�L�L�;� � � �E�N�D� � � �E�L�S�E� � � � �B�E�G�I�N� � � � �S�E�T� �@�n�e�w�O�w�n�e�r� �=� �@�h�o�s�t�I�d�;� � � � � � �I�F� �@�l�o�c�k�T�i�m�e�o�u�t� �=� �0� � � � � �S�E�T� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �=� �'�9�9�9�9�-�1�2�-�3�1�T�2�3�:�5�9�:�5�9�'�;� � � � �E�L�S�E� � � � � �S�E�T� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �=� �d�a�t�e�a�d�d�(�s�e�c�o�n�d�,� �@�l�o�c�k�T�i�m�e�o�u�t�,� �@�n�o�w�)�;� � � �E�N�D� � � � � �I�N�S�E�R�T� �I�N�T�O� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� �(�i�d�,� �i�n�s�t�a�n�c�e�,� �i�n�s�t�a�n�c�e�X�m�l�,� �c�r�e�a�t�e�d�,� �l�a�s�t�U�p�d�a�t�e�d�,� �l�o�c�k�O�w�n�e�r�,� �l�o�c�k�E�x�p�i�r�a�t�i�o�n�)� � � � �V�A�L�U�E�S� �(�@�i�d�,� �@�i�n�s�t�a�n�c�e�,� �@�i�n�s�t�a�n�c�e�X�m�l�,� �@�n�o�w�,� �@�n�o�w�,� �@�n�e�w�O�w�n�e�r�,� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n�)�;� � � � � �I�F� �@�@�r�o�w�c�o�u�n�t� �=� �0� � � �B�E�G�I�N� � � � �I�F� �E�X�I�S�T�S�(�S�E�L�E�C�T� �1� �F�R�O�M� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� �W�H�E�R�E� �i�d� �=� �@�i�d�)� � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �1�;� �-�-� �T�h�e� �i�n�s�t�a�n�c�e� �a�l�r�e�a�d�y� �e�x�i�s�t�e�d�.� � � � �E�L�S�E� � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �2�;� �-�-� �S�o�m�e� �o�t�h�e�r� �n�o�n�-�f�a�t�a�l� �e�r�r�o�r� �c�a�u�s�e�d� �u�s� �n�o�t� �t�o� �i�n�s�e�r�t� � � �E�N�D� � �E�N�D� � �G�O� � �G�R�A�N�T� �E�X�E�C�U�T�E� �O�N� �[�d�b�o�]�.�[�I�n�s�e�r�t�I�n�s�t�a�n�c�e�]� �T�O� �p�e�r�s�i�s�t�e�n�c�e�U�s�e�r�s� � �G�O� � � � �-�-� � �-�-� �U�p�d�a�t�e�I�n�s�t�a�n�c�e� � �-�-� � �I�F� �E�X�I�S�T�S� �(�S�E�L�E�C�T� �*� �F�R�O�M� �s�y�s�.�o�b�j�e�c�t�s� �W�H�E�R�E� �o�b�j�e�c�t�_�i�d� �=� �O�B�J�E�C�T�_�I�D�(�N�'�[�d�b�o�]�.�[�U�p�d�a�t�e�I�n�s�t�a�n�c�e�]�'�)� �A�N�D� �t�y�p�e� �i�n� �(�N�'�P�'�,� �N�'�P�C�'�)�)� � � �D�R�O�P� �P�R�O�C�E�D�U�R�E� �[�d�b�o�]�.�[�U�p�d�a�t�e�I�n�s�t�a�n�c�e�]� � �G�O� � �C�R�E�A�T�E� �P�R�O�C�E�D�U�R�E� �U�p�d�a�t�e�I�n�s�t�a�n�c�e� � � �@�i�d� �u�n�i�q�u�e�i�d�e�n�t�i�f�i�e�r�,� � � �@�i�n�s�t�a�n�c�e� �i�m�a�g�e� �=� �N�U�L�L�,� � � �@�i�n�s�t�a�n�c�e�X�m�l� �x�m�l� �=� �N�U�L�L�,� � � �@�u�n�l�o�c�k�I�n�s�t�a�n�c�e� �b�i�t�,� � � �@�h�o�s�t�I�d� �u�n�i�q�u�e�i�d�e�n�t�i�f�i�e�r�,� � � �@�l�o�c�k�T�i�m�e�o�u�t� �i�n�t�,� � � �@�r�e�s�u�l�t� �i�n�t� �O�U�T�P�U�T� � �A�S� � �B�E�G�I�N� � � �S�E�T� �N�O�C�O�U�N�T� �O�N�;� � � � � �S�E�T� �T�R�A�N�S�A�C�T�I�O�N� �I�S�O�L�A�T�I�O�N� �L�E�V�E�L� �R�E�A�D� �C�O�M�M�I�T�T�E�D�;� � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �0�;� � � � � �D�E�C�L�A�R�E� �@�n�o�w� �d�a�t�e�t�i�m�e�,� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �d�a�t�e�t�i�m�e�,� �@�n�e�w�O�w�n�e�r� �u�n�i�q�u�e�i�d�e�n�t�i�f�i�e�r�;� � � �S�E�T� �@�n�o�w� �=� �g�e�t�u�t�c�d�a�t�e�(�)�;� � � � � � �I�F� �@�l�o�c�k�T�i�m�e�o�u�t� �<� �0� �O�R� �@�u�n�l�o�c�k�I�n�s�t�a�n�c�e� �=� �'�T�R�U�E�'� � � �B�E�G�I�N� � � � �S�E�T� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �=� �N�U�L�L�;� � � � �S�E�T� �@�n�e�w�O�w�n�e�r� �=� �N�U�L�L�;� � � �E�N�D� � � �E�L�S�E� � � � �B�E�G�I�N� � � � �S�E�T� �@�n�e�w�O�w�n�e�r� �=� �@�h�o�s�t�I�d�;� � � � � � �I�F� �@�l�o�c�k�T�i�m�e�o�u�t� �=� �0� � � � � �S�E�T� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �=� �'�9�9�9�9�-�1�2�-�3�1�T�2�3�:�5�9�:�5�9�'�;� � � � �E�L�S�E� � � � � �S�E�T� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �=� �d�a�t�e�a�d�d�(�s�e�c�o�n�d�,� �@�l�o�c�k�T�i�m�e�o�u�t�,� �@�n�o�w�)�;� � � �E�N�D� � � � � �U�P�D�A�T�E� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� �S�E�T� � � � �i�n�s�t�a�n�c�e� �=� �@�i�n�s�t�a�n�c�e�,� � � � �i�n�s�t�a�n�c�e�X�m�l� �=� �@�i�n�s�t�a�n�c�e�X�m�l�,� � � � �l�a�s�t�U�p�d�a�t�e�d� �=� �@�n�o�w�,� � � � �l�o�c�k�O�w�n�e�r� �=� �@�n�e�w�O�w�n�e�r�,� � � � �l�o�c�k�E�x�p�i�r�a�t�i�o�n� �=� �@�l�o�c�k�E�x�p�i�r�a�t�i�o�n� � � � �W�H�E�R�E� �(�i�d� �=� �@�i�d�)� �A�N�D� �(�(�@�l�o�c�k�T�i�m�e�o�u�t� �<� �0�)� �O�R� �(�(�l�o�c�k�O�w�n�e�r� �=� �@�h�o�s�t�I�d�)� �A�N�D� �(�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �>�=� �@�n�o�w�)�)�)�;� � � � � �I�F� �@�@�r�o�w�c�o�u�n�t� �=� �0� � � �B�E�G�I�N� � � � �I�F� �E�X�I�S�T�S�(�S�E�L�E�C�T� �1� �F�R�O�M� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� �W�H�E�R�E� �i�d� �=� �@�i�d�)� � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �2�;� �-�-� �D�i�d� �n�o�t� �h�a�v�e� �l�o�c�k� � � � �E�L�S�E� � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �1�;� �-�-� �I�n�s�t�a�n�c�e� �w�a�s� �n�o�t� �f�o�u�n�d� �i�n� �t�h�e� �d�a�t�a�b�a�s�e� �f�o�r� �u�p�d�a�t�e� � � �E�N�D� � �E�N�D� � �G�O� � �G�R�A�N�T� �E�X�E�C�U�T�E� �O�N� �[�d�b�o�]�.�[�U�p�d�a�t�e�I�n�s�t�a�n�c�e�]� �T�O� �p�e�r�s�i�s�t�e�n�c�e�U�s�e�r�s� � �G�O� � � � �-�-� � �-�-� �U�n�l�o�c�k�I�n�s�t�a�n�c�e� � �-�-� � �I�F� �E�X�I�S�T�S� �(�S�E�L�E�C�T� �*� �F�R�O�M� �s�y�s�.�o�b�j�e�c�t�s� �W�H�E�R�E� �o�b�j�e�c�t�_�i�d� �=� �O�B�J�E�C�T�_�I�D�(�N�'�[�d�b�o�]�.�[�U�n�l�o�c�k�I�n�s�t�a�n�c�e�]�'�)� �A�N�D� �t�y�p�e� �i�n� �(�N�'�P�'�,� �N�'�P�C�'�)�)� � � �D�R�O�P� �P�R�O�C�E�D�U�R�E� �[�d�b�o�]�.�[�U�n�l�o�c�k�I�n�s�t�a�n�c�e�]� � �G�O� � �C�R�E�A�T�E� �P�R�O�C�E�D�U�R�E� �U�n�l�o�c�k�I�n�s�t�a�n�c�e� � � �@�i�d� �u�n�i�q�u�e�I�d�e�n�t�i�f�i�e�r�,� � � �@�h�o�s�t�I�d� �u�n�i�q�u�e�I�d�e�n�t�i�f�i�e�r�,� � � �@�l�o�c�k�T�i�m�e�o�u�t� �i�n�t�,� � � �@�r�e�s�u�l�t� �i�n�t� �o�u�t�p�u�t� � �A�S� � �B�E�G�I�N� � � �S�E�T� �N�O�C�O�U�N�T� �O�N�;� � � � � �S�E�T� �T�R�A�N�S�A�C�T�I�O�N� �I�S�O�L�A�T�I�O�N� �L�E�V�E�L� �R�E�A�D� �C�O�M�M�I�T�T�E�D� � � � � �D�E�C�L�A�R�E� �@�n�o�w� �d�a�t�e�t�i�m�e�;� � � �S�E�T� �@�n�o�w� �=� �g�e�t�u�t�c�d�a�t�e�(�)�;� � � � � �U�P�D�A�T�E� �[�I�n�s�t�a�n�c�e�D�a�t�a�]� �S�E�T� � � � �l�o�c�k�O�w�n�e�r� �=� �N�U�L�L�,� � � � �l�o�c�k�E�x�p�i�r�a�t�i�o�n� �=� �N�U�L�L� � � � �W�H�E�R�E� �(�i�d� �=� �@�i�d�)� �A�N�D� �(�(�@�l�o�c�k�T�i�m�e�o�u�t� �<� �0�)� �O�R� �(�(�l�o�c�k�O�w�n�e�r� �=� �@�h�o�s�t�I�d�)� �A�N�D� �(�l�o�c�k�E�x�p�i�r�a�t�i�o�n� �>�=� �@�n�o�w�)�)�)�;� � � � � �I�F� �@�@�r�o�w�c�o�u�n�t� �=� �1� � � � �S�E�T� �@�r�e�s�u�l�t� �=� �0�;� �-�-� �S�u�c�c�e�s�s� � � �E�L�S�E� � � �B�E�G�I�N� � � � �I�F� �E�X�I�S�T�S�(�S�E�L�E�C�T� �1� �F�R�O�M� �[�d�b�o�]�.�[�I�n�s�t�a�n�c�e�D�a�t�a�]� �W�H�E�R�E� �i�d� �=� �@�i�d�)� � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �2�;� �-�-� �D�i�d� �n�o�t� �h�a�v�e� �l�o�c�k� � � � �E�L�S�E� � � � � �S�E�T� �@�r�e�s�u�l�t� �=� �1�;� �-�-� �I�n�s�t�a�n�c�e� �n�o�t� �f�o�u�n�d� � � �E�N�D� � �E�N�D� � �G�O� � �G�R�A�N�T� �E�X�E�C�U�T�E� �O�N� �[�d�b�o�]�.�[�U�n�l�o�c�k�I�n�s�t�a�n�c�e�]� �T�O� �p�e�r�s�i�s�t�e�n�c�e�U�s�e�r�s� � �G�O� � �
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de