Karşılaşabileceğiniz bazı hata çözümleri ve dikkat edilmesi gereken noktalar:




ALTER FUNCTION [dbo].[NETPROCESSID]()
RETURNS VARCHAR(75)
WITH SCHEMABINDING
AS
BEGIN
DECLARE @APPNAME VARCHAR(50);
DECLARE @RESULT VARCHAR(75)

SET @APPNAME = APP_NAME();


IF SUBSTRING(@APPNAME,1,10) = 'NETSISWEB'
BEGIN
DECLARE @LENGTH TINYINT
DECLARE @CTX VARBINARY(128)

SET @CTX = CONTEXT_INFO()
SET @LENGTH = CONVERT(TINYINT, SUBSTRING(@CTX, 1, 1))
SET @RESULT = CONVERT(VARCHAR(127), SUBSTRING(@CTX, 2, @LENGTH))
END
ELSE IF SUBSTRING(@APPNAME,1,4) = 'RC20'
BEGIN
SET @RESULT=('REDCODE20' + '_' + @APPNAME)
END
ELSE IF @APPNAME = '444082'
BEGIN
SET @RESULT=(HOST_NAME()+'_'+LTRIM(CAST(CAST(GETDATE() AS DECIMAL) AS VARCHAR(15))) + '_' + @APPNAME)
END
ELSE
BEGIN
SET @RESULT=(HOST_NAME() + '_' + HOST_ID() + '_' + @APPNAME)
END

RETURN @RESULT
END






Hata örnek görüntüsü: