Database	Proc	Application	Created	Links
sybsystemprocs	sp_getmessage		31 Aug 14	Defects Dependencies

1     
2     
3     /* generic/sproc/getmessage	14.2	4/25/91 */
4     
5     /* Messages from sysmessages
6     ** 17200, "Message number must be greater than or equal to 17000."
7     ** 17201, "'%1!' is not an official language name from Syslanguages."
8     ** 17202, "Message number %1! does not exist in the %2! language."
9     */
10    
11    create procedure sp_getmessage
12        @message_num int,
13        @result varchar(1024) output,
14        @language varchar(30) = NULL
15    as
16    
17        declare @lang_id smallint
18        declare @msg varchar(1024)
19        declare @returncode smallint
20    
21        if @@trancount = 0
22        begin
23            set chained off
24        end
25    
26        set transaction isolation level 1
27    
28        /* 
29        ** Use default language if none specified, 
30        ** and initialize result 
31        */
32        select @lang_id = @@langid, @result = NULL
33    
34        /* Only retrieve external errors */
35        if @message_num < 17000
36        BEGIN
37            /* 17200   "Message number must be greater than or equal to 17000." */
38            select @msg = description from master.dbo.sysmessages
39            where error = 17200
40            print @msg
41            return (1)
42        END
43    
44        /*
45        ** Check that language is valid.
46        */
47        if @language is not NULL
48        BEGIN
49            execute @returncode = sp_validlang @language
50            if @returncode != 0
51            begin
52                /* Us_english is always valid */
53                if @language != "us_english"
54                BEGIN
55                    /* 
56                    ** 17201, "'%1!' is not an official language
57                    **	name from Syslanguages."
58                    */
59                    select @msg = description from master.dbo.sysmessages
60                    where error = 17201
61                        and langid = @@langid
62    
63                    /* Get english if the current language is missing */
64                    if @msg is null
65                        select @msg = description from master.dbo.sysmessages
66                        where error = 17201
67                            and langid is NULL
68    
69                    print @msg, @language
70                    return @returncode
71                END
72    
73                /* set to us_english */
74                select @lang_id = NULL
75            end
76    
77            else
78                select @lang_id = langid from master.dbo.syslanguages
79                where @language = name
80    
81        END
82    
83        /* The langid is assigned 0 since it gets its value from @@langid. */
84        /* For us_english, we have to insert it as NULL and not 0, this is */
85        /* to maintain compatibility with the current conventions          */
86        if @lang_id = 0
87        begin
88            select @lang_id = NULL
89        end
90    
91        /* Get message from the proper place */
92        /* System messages */
93        if @message_num < 20000
94        BEGIN
95            select @result = description from master.dbo.sysmessages
96            where langid = @lang_id
97                and error = @message_num
98    
99            /* Get english if the current language is missing */
100           if @result is null
101               select @result = description from master.dbo.sysmessages
102               where error = @message_num
103                   and (langid is NULL or langid = 0)
104       END
105       else
106       /* User messages */
107       BEGIN
108           /* There is no proper alternate language for user messages */
109           select @result = description from sysusermessages
110           where langid = @lang_id
111               and error = @message_num
112   
113           /* this is in here for compatibility with older revs which */
114           /* by mistake used to add langid as 0 in sysusermessages   */
115           if @result is null and @lang_id is NULL
116               select @result = description from sysusermessages
117               where (langid = 0 or langid is NULL)
118                   and error = @message_num
119   
120       END
121   
122       /* Warn the user if the message can't be found */
123       if @result is null
124       begin
125           /* 17202, "Message number %1! does not exist in the %2! language." */
126           select @msg = description from master.dbo.sysmessages
127           where error = 17202
128               and langid = @@langid
129   
130           if @language is null
131               select @language = @@language
132   
133           if @msg is null
134               select @msg = "Message number %1! does not exist in the %2! language."
135   
136           print @msg, @message_num, @language
137   
138           return (1)
139       end
140   
141       return (0)
142



exec sp_procxmode 'sp_getmessage', 'AnyMode'
go

Grant Execute on sp_getmessage to public
go

DEFECTS
MINU 4 Unique Index with nullable columns master..syslanguages	master..syslanguages
MINU 4 Unique Index with nullable columns master..sysmessages	master..sysmessages
MINU 4 Unique Index with nullable columns sybsystemprocs..sysusermessages	sybsystemprocs..sysusermessages
MTYP 4 Assignment type mismatch @lang_id: smallint = int	32
QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int	61
QTYP 4 Comparison type mismatch smallint = int	61
QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int	103
QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int	117
QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int	128
QTYP 4 Comparison type mismatch smallint = int	128
MGTP 3 Grant to public master..syslanguages
MGTP 3 Grant to public master..sysmessages
MGTP 3 Grant to public sybsystemprocs..sp_getmessage
MGTP 3 Grant to public sybsystemprocs..sysusermessages
MUCO 3 Useless Code Useless Brackets	41
MUCO 3 Useless Code Useless Brackets	138
MUCO 3 Useless Code Useless Brackets	141
QAFM 3 Var Assignment from potentially many rows	38
QAFM 3 Var Assignment from potentially many rows	59
QAFM 3 Var Assignment from potentially many rows	65
QAFM 3 Var Assignment from potentially many rows	95
QAFM 3 Var Assignment from potentially many rows	101
QAFM 3 Var Assignment from potentially many rows	126
QISO 3 Set isolation level	26
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error}	39
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error, langid}	60
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error, langid}	66
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error, langid}	96
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error, langid}	102
QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysmessages.ncsysmessages unique (error, dlevel, langid) Intersection: {error, langid}	127
MTR1 2 Metrics: Comments Ratio Comments: 34%	11
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 21 = 23dec - 4exi + 2	11
MTR3 2 Metrics: Query Complexity Complexity: 82	11