March 26, 2020 at 8:54 am
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
March 26, 2020 at 4:52 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy