DatabaseProcApplicationCreatedLinks
sybsystemprocssp_makesuspect_obj  14 déc. 14Defects Propagation Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/%M% %I% %G% */
3     
4     /*
5     ** 17260, "Can't run %1! from within a transaction." 
6     ** 17421, "No such database -- run sp_helpdb to list databases."
7     ** 17422, "The 'master' database's options can not be changed."
8     ** 17428, "You must be in the 'master' database in order to change
9     **	database options."                                
10    */
11    /*
12    **************************  WARNING   WARNING   WARNING ************************
13    **************************  WARNING   WARNING   WARNING ************************
14    ** This stored procedure is only meant for testing and testing ONLY - to test **
15    ** the Recovery Fault Isolation (RFI) feature by simulating various types of  **
16    ** corruptions and isolating them during recovery using RFI feature.          ** 
17    ** This should never be used in any production environment.                   **
18    ********************************************************************************
19    */
20    create or replace procedure sp_makesuspect_obj
21        @dbname varchar(30) = NULL,
22        @objname varchar(30) = NULL,
23        @indid int = 0,
24        @logtype int = - 2,
25        @pgtype int = - 2,
26        @errtype int = - 2,
27        @errorcnt int = 0,
28        @errdelay int = 0
29    as
30        declare @dbid int, /* dbid of the database */
31            @attrib_id int,
32            @action int,
33            @object_type varchar(2),
34            @msg varchar(250),
35            @charvalue varchar(255),
36            @sptlang int,
37            @whichone int, /* which language? */
38            @error_index int,
39            @shift16 int,
40            @objid int,
41            @class int,
42            @indid_offset int,
43            @logtype_offset int,
44            @pgtype_offset int,
45            @errtype_offset int,
46            @errorcnt_offset int,
47            @errdelay_offset int,
48            @nullarg char(1),
49            @dummy int,
50            @status int,
51            @gp_enabled int
52    
53    
54    
55    
56    
57    
58        select @attrib_id = 5 /* attribute is SUSPECT error */
59        select @object_type = 'D'
60        select @class = 10
61    
62        select @indid_offset = 1
63        select @logtype_offset = 9
64        select @pgtype_offset = 17
65        select @errtype_offset = 25
66        select @errorcnt_offset = 33
67        select @errdelay_offset = 41
68    
69        if @@trancount = 0
70        begin
71            set chained off
72        end
73    
74        set transaction isolation level 1
75    
76        select @sptlang = @@langid, @whichone = 0
77    
78        if @@langid != 0
79        begin
80            if not exists (
81                    select * from master.dbo.sysmessages where error
82                        between 17050 and 17069
83                        and langid = @@langid)
84                select @sptlang = 0
85        end
86    
87    
88        /*
89        **  If no @dbname given, assume the current database
90        */
91    
92        if @dbname is null
93            select @dbname = db_name()
94    
95        /*
96        **  Verify the database name and get the @dbid 
97        */
98        select @dbid = dbid from master.dbo.sysdatabases
99        where name = @dbname
100   
101       /*
102       **  If @dbname not found, say so.
103       */
104       if @dbid is NULL
105       begin
106           /*
107           ** 17421, "No such database -- run sp_helpdb to list databases."
108           */
109           raiserror 17421
110           return (1)
111       end
112   
113       /* get the object id  */
114       if @objname is null
115           select @objid = - 1
116       else
117           select @objid = object_id(@dbname + '..' + @objname)
118   
119       if @objid is null AND @objname != "simobj" AND @objname != "allocobj"
120       BEGIN
121           /*
122           **	xxxx0, Suspect error value %2 is not valid
123           */
124           /*exec sp_getmessage xxxx0, @msg output
125           print @msg*/
126           print "Invalid Object in the database"
127           return (1)
128       END
129       if @objname = "simobj"
130       begin
131           select @objid = 0
132           select @errtype = 0
133           select @pgtype = 0
134           select @errorcnt = 0
135           select @errdelay = 0
136       end
137   
138       /*
139       ** If only dbname is provided, then display the setting
140       */
141   
142       if @errtype = - 2
143       begin
144           if (@objid = - 1)
145           begin
146               select "DBName" = convert(varchar(15), @dbname),
147                   "Obj" = convert(varchar(15), object_name(object_info1, @dbid)),
148                   "Indid" = substring(char_value, @indid_offset, 5),
149                   "LogType" = substring(char_value, @logtype_offset, 5),
150                   "PageType" = substring(char_value, @pgtype_offset, 5),
151                   "ErrType" = substring(char_value, @errtype_offset, 5),
152                   "Delay" = substring(char_value, @errorcnt_offset, 5),
153                   "TotalNum" = substring(char_value, @errdelay_offset, 5)
154               from master.dbo.sysattributes
155               where class = @class AND
156                   attribute = @attrib_id AND
157                   object_type = @object_type AND
158                   object = @dbid
159           end
160           else
161           begin
162               select "DBName" = convert(varchar(15), @dbname),
163                   "Obj" = convert(varchar(15), object_name(object_info1, @dbid)),
164                   "Indid" = substring(char_value, @indid_offset, 5),
165                   "LogType" = substring(char_value, @logtype_offset, 5),
166                   "PageType" = substring(char_value, @pgtype_offset, 5),
167                   "ErrType" = substring(char_value, @errtype_offset, 5),
168                   "Delay" = substring(char_value, @errorcnt_offset, 5),
169                   "TotalNum" = substring(char_value, @errdelay_offset, 5)
170               from master.dbo.sysattributes
171               where class = @class AND
172                   attribute = @attrib_id AND
173                   object_type = @object_type AND
174                   object = @dbid AND
175                   object_info1 = @objid AND
176                   substring(char_value, 0, 8) = convert(char(8), @indid)
177           end
178   
179   
180           /*	select 	"DB Name" = @dbname,
181           **		"Error Type" = @errortype,
182           **		"Error Freq" = @error_freq 
183           */
184           return (0)
185       end
186   
187       /* 
188       ** The role sybase_ts_role is required regardless if granular permissions is
189       ** enabled or not.  
190       ** proc_role will also do auditing if required. It will also print 
191       ** error message if required.
192       */
193   
194       select @nullarg = NULL
195       execute @status = sp_aux_checkroleperm "sybase_ts_role", "sybase_ts_role",
196           @nullarg, @gp_enabled output
197   
198       /* For Auditing */
199       if (@status != 0)
200       begin
201           if (proc_role("sybase_ts_role") = 0)
202               return (1)
203       end
204   
205       if @dbid = 1
206       begin
207           /*
208           ** 17422, "The 'master' database's options can not be changed."
209           */
210           raiserror 17422
211           return (1)
212       end
213   
214       if db_name() != "master"
215       begin
216           /*
217           ** 17428, "You must be in the 'master' database in order to change database options."                                
218           */
219           raiserror 17428
220           return (1)
221       end
222   
223       /*
224       **  If we're in a transaction, disallow this since it might make recovery
225       **  impossible.
226       */
227       if @@trancount > 0
228       begin
229           /*
230           ** 17260, "Can't run %1! from within a transaction." 
231           */
232           raiserror 17260, "sp_makesuspect_obj"
233           return (1)
234       end
235       else
236       begin
237           set chained off
238       end
239   
240       set transaction isolation level 1
241   
242       /*
243       ** Check to see that the input params are correct and then hook up with
244       ** Sysattributes table to enter data.
245       */
246   
247   
248       if (@errtype < - 1) OR (@errtype > 50) or
249           (@pgtype < - 1) or (@pgtype > 8) or
250           (@logtype < - 1) or (@logtype > 58) or
251           (@errorcnt < 0) or (@errorcnt > 999999) or
252           (@errdelay < 0) or (@errdelay > 999999)
253       BEGIN
254           /*
255           **	xxxx0, Suspect error value %2 is not valid
256           */
257           /*exec sp_getmessage xxxx0, @msg output
258           print @msg*/
259           print "Invalid suspect error value"
260           return (1)
261       END
262       select @charvalue = convert(char(8), @indid) + convert(char(8), @logtype) +
263           convert(char(8), @pgtype) + convert(char(8), @errtype) +
264           convert(char(8), @errorcnt) + convert(char(8), @errdelay)
265   
266       /*
267       ** if an entry already exists for this database then delet the entry,
268       ** and insert a new row for this database.
269       */
270       IF exists (select * from master.dbo.sysattributes where
271                   class = @class AND
272                   attribute = @attrib_id AND
273                   object_type = @object_type AND
274                   object = @dbid AND
275                   object_info1 = @objid AND
276                   substring(char_value, @indid_offset, 8) = convert(char(8), @indid) AND
277                   substring(char_value, @logtype_offset, 8) = convert(char(8), @logtype) AND
278                   substring(char_value, @pgtype_offset, 8) = convert(char(8), @pgtype) AND
279                   substring(char_value, @errtype_offset, 8) = convert(char(8), @errtype))
280       begin
281           /* save the error index and delete the row */
282           select @error_index = object_info2 from master.dbo.sysattributes where
283               class = @class AND
284               attribute = @attrib_id AND
285               object_type = @object_type AND
286               object = @dbid AND
287               object_info1 = @objid AND
288               substring(char_value, @indid_offset, 8) = convert(char(8), @indid) AND
289               substring(char_value, @logtype_offset, 8) = convert(char(8), @logtype) AND
290               substring(char_value, @pgtype_offset, 8) = convert(char(8), @pgtype) AND
291               substring(char_value, @errtype_offset, 8) = convert(char(8), @errtype)
292           delete master.dbo.sysattributes
293           where class = @class AND
294               attribute = @attrib_id AND
295               object_type = @object_type AND
296               object = @dbid AND
297               object_info1 = @objid AND
298               substring(char_value, @indid_offset, 8) = convert(char(8), @indid) AND
299               substring(char_value, @logtype_offset, 8) = convert(char(8), @logtype) AND
300               substring(char_value, @pgtype_offset, 8) = convert(char(8), @pgtype) AND
301               substring(char_value, @errtype_offset, 8) = convert(char(8), @errtype)
302       end
303       else
304       begin
305           /* create a new error index which is got by incrementing the previous highest
306           error index*/
307           select @error_index = 0
308           if (@objname = "simobj")
309               select @error_index = 0
310           else
311           begin
312               select @error_index = 1
313               while exists (select * from master.dbo.sysattributes where
314                           class = @class AND
315                           attribute = @attrib_id AND
316                           object_type = @object_type AND
317                           object_info2 = @error_index)
318               begin
319                   select @error_index = @error_index + 1
320               end
321           end
322       end
323       insert master.dbo.sysattributes
324       (class, attribute, object_type, object, object_info1, object_info2, char_value)
325       values (@class, @attrib_id, @object_type, @dbid, @objid, @error_index, @charvalue)
326   
327   
328   
329       /*
330       ** Display the setting 
331       */
332   
333       select "DBName" = convert(varchar(15), @dbname),
334           "Obj" = convert(varchar(15), object_name(object_info1, @dbid)),
335           "Indid" = substring(char_value, @indid_offset, 5),
336           "LogType" = substring(char_value, @logtype_offset, 5),
337           "PageType" = substring(char_value, @pgtype_offset, 5),
338           "ErrType" = substring(char_value, @errtype_offset, 5),
339           "Delay" = substring(char_value, @errorcnt_offset, 5),
340           "TotalNum" = substring(char_value, @errdelay_offset, 5)
341       from master.dbo.sysattributes
342       where class = @class AND
343           attribute = @attrib_id AND
344           object_type = @object_type AND
345           object = @dbid AND
346           object_info1 = @objid AND
347           substring(char_value, @indid_offset, 8) = convert(char(8), @indid) AND
348           substring(char_value, @logtype_offset, 8) = convert(char(8), @logtype) AND
349           substring(char_value, @pgtype_offset, 8) = convert(char(8), @pgtype) AND
350           substring(char_value, @errtype_offset, 8) = convert(char(8), @errtype)
351   
352   
353       /*
354       ** xxxx3, "The new suspect granularity will become effective
355       **			during next load/boot time recovery"
356       */
357       /*exec sp_getmessage xxxx1, @msg output
358       print @msg*/
359       print "This error value will effective with next recovery of db"
360       return (0)
361   
362   


Grant Execute on sp_makesuspect_obj to sybase_ts_role
go
RESULT SETS
sp_makesuspect_obj_rset_003
sp_makesuspect_obj_rset_002
sp_makesuspect_obj_rset_001

DEFECTS
 MINU 4 Unique Index with nullable columns master..sysattributes master..sysattributes
 MINU 4 Unique Index with nullable columns master..sysmessages master..sysmessages
 MTYP 4 Assignment type mismatch attribute: smallint = int 325
 MTYP 4 Assignment type mismatch class: smallint = int 325
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 83
 QTYP 4 Comparison type mismatch smallint = int 83
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 155
 QTYP 4 Comparison type mismatch smallint = int 155
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 156
 QTYP 4 Comparison type mismatch smallint = int 156
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 171
 QTYP 4 Comparison type mismatch smallint = int 171
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 172
 QTYP 4 Comparison type mismatch smallint = int 172
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 271
 QTYP 4 Comparison type mismatch smallint = int 271
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 272
 QTYP 4 Comparison type mismatch smallint = int 272
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 283
 QTYP 4 Comparison type mismatch smallint = int 283
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 284
 QTYP 4 Comparison type mismatch smallint = int 284
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 293
 QTYP 4 Comparison type mismatch smallint = int 293
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 294
 QTYP 4 Comparison type mismatch smallint = int 294
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 314
 QTYP 4 Comparison type mismatch smallint = int 314
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 315
 QTYP 4 Comparison type mismatch smallint = int 315
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 342
 QTYP 4 Comparison type mismatch smallint = int 342
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 343
 QTYP 4 Comparison type mismatch smallint = int 343
 MGTP 3 Grant to public master..sysattributes  
 MGTP 3 Grant to public master..sysdatabases  
 MGTP 3 Grant to public master..sysmessages  
 MNER 3 No Error Check should check @@error after delete 292
 MNER 3 No Error Check should check @@error after insert 323
 MUCO 3 Useless Code Useless Brackets 110
 MUCO 3 Useless Code Useless Brackets 127
 MUCO 3 Useless Code Useless Brackets 144
 MUCO 3 Useless Code Useless Brackets 184
 MUCO 3 Useless Code Useless Brackets 199
 MUCO 3 Useless Code Useless Brackets 201
 MUCO 3 Useless Code Useless Brackets 202
 MUCO 3 Useless Code Useless Brackets 211
 MUCO 3 Useless Code Useless Brackets 220
 MUCO 3 Useless Code Useless Brackets 233
 MUCO 3 Useless Code Useless Brackets 260
 MUCO 3 Useless Code Useless Brackets 308
 MUCO 3 Useless Code Useless Brackets 360
 MUOT 3 Updates outside transaction 323
 QAFM 3 Var Assignment from potentially many rows 282
 QCRS 3 Conditional Result Set 146
 QCRS 3 Conditional Result Set 162
 QISO 3 Set isolation level 74
 QISO 3 Set isolation level 240
 QIWC 3 Insert with not all columns specified missing 8 columns out of 15 324
 QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysmessages.ncsysmessages unique
(error, dlevel, langid)
Intersection: {error, langid}
81
 QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object, attribute, class}
155
 QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, object_type, object_info1, object, class}
171
 QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, class, object, object_type, object_info1}
271
 QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, class, object, object_type, object_info1}
283
 QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, class, object, object_type, object_info1}
293
 QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {object_type, object_info2, attribute, class}
314
 QPRI 3 Join or Sarg with Rooted Partial Index Use SARG Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute, class, object, object_type, object_info1}
342
 VNRD 3 Variable is not read @whichone 76
 VNRD 3 Variable is not read @sptlang 84
 VNRD 3 Variable is not read @gp_enabled 196
 VUNU 3 Variable is not used @action 32
 VUNU 3 Variable is not used @msg 34
 VUNU 3 Variable is not used @shift16 39
 VUNU 3 Variable is not used @dummy 49
 MRST 2 Result Set Marker 146
 MRST 2 Result Set Marker 162
 MRST 2 Result Set Marker 333
 MSUB 2 Subquery Marker 80
 MSUB 2 Subquery Marker 270
 MSUB 2 Subquery Marker 313
 MTR1 2 Metrics: Comments Ratio Comments: 25% 20
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 45 = 52dec - 9exi + 2 20
 MTR3 2 Metrics: Query Complexity Complexity: 167 20

DATA PROPAGATION detailed
ColumnWritten To
@dbnamesysattributes.object_info1   °.char_value   sysattributes.object_info1   °.int_value   °.char_value   sp_dropdevice_rset_001.device sp_displayroles_rset_001.Role Name sp_displayroles_rset_002.Role Name sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name
sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Object °.status sp_forceonline_object_rset_002.Object °.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Object °.Access sp_listsuspect_page_rset_001.Object
°.Access sp_makesuspect_obj_rset_001.DBName °.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.DBName
°.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.DBName °.Obj °.Indid
°.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_memlog_rset_001.dumps_per_file sp_passwordpolicy_rset_001.message sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option
sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@errdelaysysattributes.char_value   sysattributes.int_value   °.char_value   sp_dropdevice_rset_001.device sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.status sp_forceonline_object_rset_002.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Access
sp_listsuspect_page_rset_001.Access sp_makesuspect_obj_rset_001.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Indid °.LogType °.PageType
°.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_passwordpolicy_rset_001.message
sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@errorcntsysattributes.char_value   sysattributes.int_value   °.char_value   sp_dropdevice_rset_001.device sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.status sp_forceonline_object_rset_002.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Access
sp_listsuspect_page_rset_001.Access sp_makesuspect_obj_rset_001.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Indid °.LogType °.PageType
°.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_passwordpolicy_rset_001.message
sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@errtypesysattributes.char_value   sysattributes.int_value   °.char_value   sp_dropdevice_rset_001.device sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.status sp_forceonline_object_rset_002.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Access
sp_listsuspect_page_rset_001.Access sp_makesuspect_obj_rset_001.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Indid °.LogType °.PageType
°.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_passwordpolicy_rset_001.message
sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@indidsysattributes.char_value   sysattributes.int_value   °.char_value   sp_dropdevice_rset_001.device sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.status sp_forceonline_object_rset_002.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Access
sp_listsuspect_page_rset_001.Access sp_makesuspect_obj_rset_001.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Indid °.LogType °.PageType
°.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_passwordpolicy_rset_001.message
sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@logtypesysattributes.char_value   sysattributes.int_value   °.char_value   sp_dropdevice_rset_001.device sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.status sp_forceonline_object_rset_002.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Access
sp_listsuspect_page_rset_001.Access sp_makesuspect_obj_rset_001.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Indid °.LogType °.PageType
°.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_passwordpolicy_rset_001.message
sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@objnamesysattributes.object_info1   °.char_value   sysattributes.object_info1   °.int_value   °.char_value   sp_dropdevice_rset_001.device sp_displayroles_rset_001.Role Name sp_displayroles_rset_002.Role Name sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name
sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Object °.status sp_forceonline_object_rset_002.Object °.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Object °.Access sp_listsuspect_page_rset_001.Object
°.Access sp_makesuspect_obj_rset_001.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Obj °.Indid
°.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Obj °.Indid °.LogType °.PageType °.ErrType
°.Delay °.TotalNum sp_memlog_rset_001.dumps_per_file sp_passwordpolicy_rset_001.message sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_ssladmin_rset_001.certificate_path
sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@pgtypesysattributes.char_value   sysattributes.int_value   °.char_value   sp_dropdevice_rset_001.device sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.status sp_forceonline_object_rset_002.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Access
sp_listsuspect_page_rset_001.Access sp_makesuspect_obj_rset_001.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Indid °.LogType °.PageType
°.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_passwordpolicy_rset_001.message
sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_makesuspect_obj_rset_001 
reads table master..sysmessages (1)  
read_writes table master..sysattributes (1)  
calls proc sybsystemprocs..sp_aux_checkroleperm  
   reads table master..syscurconfigs (1)  
   reads table master..sysconfigures (1)  
writes table sybsystemprocs..sp_makesuspect_obj_rset_003 
writes table sybsystemprocs..sp_makesuspect_obj_rset_002 
reads table master..sysdatabases (1)