SQL Server – Transact SQL - varbintohexsubstring

  • Hello there, I need your appreciated help.

    My version is :

    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) 
    Oct 14 2005 00:33:37
    Copyright (c) 1988-2005 Microsoft Corporation
    Standard Edition on Windows NT 6.1 (Build 7601: Service Pack 1)

    I have problem with this transaction :

    return sys.fn_varbintohexsubstring(1,@pbinin,1,0)

    Because on Activity Monitor of SQL Server this thread it takes up a lot of memory and a lot of CPU on the server.


    How to do resolve this ?

    Thanks in advance for any help.




  • Guido :-

    You cannot really resolve the issue.

    Are you using encryption.

    If you are using encryption the varbintohexsubstring function is used by DecryptByKey and other decryption routines.

    Daniel Adeniji



Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply