DatabaseProcApplicationCreatedLinks
sybsystemprocssp_config_dump  14 déc. 14Defects Propagation Dependencies

1     /* This stored procedure is for configuring dump options.
2     **
3     **	Messages for sp_config_dump
4     **
5     ** 17260, "Can't run %1! from within a transaction."
6     ** 17019, "No such dump config '%1!' exists. Run sp_config_dump without parame
7     **         ters to list dump configurations."
8     ** 18703, "Please execute the procedure '%1!' from master database"	
9     **
10    */
11    create or replace procedure sp_config_dump
12        @config_name varchar(255) = NULL, /* dump config name    	   */
13        @stripe_dir varchar(255) = NULL, /* stripe dir | 'delete'   */
14        @ext_api varchar(255) = NULL, /* external api            */
15        @num_stripes varchar(30) = NULL, /* number of stripes       */
16        @retry varchar(30) = NULL, /* number of retries       */
17        @blocksize varchar(30) = NULL, /* number of bytes         */
18        @compression varchar(30) = NULL, /* compression level       */
19        @retaindays varchar(30) = NULL, /* number of days          */
20        @init varchar(30) = NULL, /* noinit | init           */
21        @verify varchar(30) = NULL, /* header | full           */
22        @notify varchar(30) = NULL, /* client | operator_console*/
23        @backup_srv_name varchar(255) = NULL /* backup server name      */
24    as
25    
26        /*
27        **  The following variable are used to print out dump configuration 
28        **  information.
29        */
30        declare @config_name_r varchar(255)
31        declare @stripe_dir_r varchar(255)
32        declare @ext_api_r varchar(255)
33        declare @num_stripes_r varchar(30)
34        declare @retry_r varchar(30)
35        declare @blocksize_r varchar(30)
36        declare @compression_r varchar(30)
37        declare @retaindays_r varchar(30)
38        declare @init_r varchar(30)
39        declare @verify_r varchar(30)
40        declare @notify_r varchar(30)
41        declare @backup_srv_name_r varchar(255)
42    
43        declare @dmp varchar(255)
44        declare @value varchar(255)
45        declare @dbid int
46        declare @i int
47        declare @attrname varchar(30)
48        declare @charvalue varchar(255)
49        declare @intvalue int
50        declare @tempblocksize int
51        declare @usage varchar(464)
52    
53        declare @has_sa_role int /* Use has sa role */
54        declare @DMPCFG_CLASS int
55        declare @OBJTYPE char(2)
56        declare @MAXRETRY int
57        declare @CMD int
58        declare @NUMOPTIONS int
59        declare @type int
60        declare @attr int
61        declare @retstat int
62        declare @nullarg char(1)
63        declare @status1 int
64        declare @status2 int
65        declare @gp_enabled int
66        declare @dummy int
67    
68        select @DMPCFG_CLASS = 40 /* sysattributes class */
69        select @OBJTYPE = "DC" /* sysattributes type  */
70        select @NUMOPTIONS = 11 /* number of dump cfg options */
71        select @MAXRETRY = 5 /* max number of retries      */
72    
73        /* Dont allow sp_dump_config to run within a transaction */
74        if @@trancount > 0
75        begin
76            raiserror 17260, "sp_dump_config"
77            return 1
78        end
79        else
80        begin
81            set transaction isolation level 1
82            set chained off
83            set nocount on
84        end
85    
86        /*
87        ** Verify that the user has sufficient permissions to
88        ** update the dump configuration
89        **
90        ** When GP is not enabled, only the accounts with either 
91        ** SA role or oper_role can execute this procedure. 
92        ** When GP is enabled, only the accounts with MANAGE DUMP CONFIGURATION 
93        ** privilege can execute this procedure.
94        */
95        select @nullarg = NULL
96        select @status1 = 1
97        select @status2 = 1
98    
99        /* sp_aux_checkroleperm will not raise error */
100       execute @status1 = sp_aux_checkroleperm "sa_role",
101           "manage dump configuration", @nullarg, @gp_enabled output
102   
103       if (@gp_enabled = 0)
104       begin
105           if (@status1 != 0)
106           begin
107               execute @status2 = sp_aux_checkroleperm "oper_role",
108                   @nullarg, @nullarg, @gp_enabled output
109   
110               if (@status2 != 0)
111               begin
112                   /* 
113                   ** proc_role() will raise permission errors
114                   ** and send audit records to the audit trail.
115                   */
116                   select @dummy = proc_role("sa_role")
117                   select @dummy = proc_role("oper_role")
118                   return 1
119               end
120           end
121   
122           /* send audit record when succeed */
123           if (@status1 = 0)
124           begin
125               select @dummy = proc_role("sa_role")
126           end
127   
128           if (@status2 = 0)
129           begin
130               select @dummy = proc_role("oper_role")
131           end
132       end
133       else
134       begin
135           select @dummy = proc_auditperm("manage dump configuration",
136                   @status1)
137           if (@status1 != 0)
138               return 1
139       end
140   
141   
142       /* Make sure that the procedure is executed from master database */
143       select @dbid = db_id()
144       if (@dbid != 1)
145       begin
146           raiserror 18703, "sp_config_dump"
147           return 1
148       end
149   
150       /* sp_config_dump dname,"delete"  will delete dname dump configuration*/
151   
152       if ((@config_name is not NULL) and (@stripe_dir = 'delete'))
153       begin
154           begin tran dumpconfig
155           if NOT EXISTS (select * from master.dbo.sysattributes
156                   where class = @DMPCFG_CLASS and object_cinfo = @config_name)
157           begin
158               raiserror 17019, @config_name
159               rollback tran dumpconfig
160               return 1
161           end
162           else
163           begin
164               select @CMD = 35
165               delete from master.dbo.sysattributes
166               where class = @DMPCFG_CLASS and object_cinfo = @config_name
167               goto mgr
168           end
169       end
170   
171   
172       /* If config name is not specified: list all existing dump configurations */
173   
174       if (@config_name is NULL)
175       begin
176           select distinct object_cinfo "dumpconfig"
177           into #dumpcfgname
178           from master.dbo.sysattributes where class = @DMPCFG_CLASS
179           exec sp_autoformat #dumpcfgname
180           return 0
181       end
182   
183       /* If 'help' is entered instead of config_name print usage */
184   
185       if (@config_name = 'help')
186       begin
187           goto print_usage
188       end
189   
190       /*
191       ** trim the leading, trailing spaces from supplied options
192       */
193   
194       select @config_name_r = ltrim(rtrim(@config_name))
195       select @stripe_dir_r = ltrim(rtrim(@stripe_dir))
196       select @ext_api_r = ltrim(rtrim(@ext_api))
197       select @num_stripes_r = ltrim(rtrim(@num_stripes))
198       select @retry_r = ltrim(rtrim(@retry))
199       select @blocksize_r = ltrim(rtrim(@blocksize))
200       select @compression_r = ltrim(rtrim(@compression))
201       select @retaindays_r = ltrim(rtrim(@retaindays))
202       select @init_r = ltrim(rtrim(@init))
203       select @verify_r = ltrim(rtrim(@verify))
204       select @notify_r = ltrim(rtrim(@notify))
205       select @backup_srv_name_r = ltrim(rtrim(@backup_srv_name))
206   
207       /*
208       ** Create a temprorary table with the names of all dump 
209       ** configuration parameters.
210       ** The first column is the dump configuration parameter
211       ** The second column is the sysattributes attribute id.
212       ** The third column is the optiontype:
213       **	1 (char),
214       **	2 (int)
215       */
216       if ((select object_id("#dump_config_table")) is not NULL)
217       begin
218           drop table #dump_config_table
219       end
220       create table #dump_config_table(optionname varchar(30), attrib_id int,
221           optiontype int, optionvalue varchar(255) NULL)
222       insert into #dump_config_table values ("stripe_dir", 0, 1, @stripe_dir_r)
223       insert into #dump_config_table values ("ext_api", 1, 1, @ext_api_r)
224       insert into #dump_config_table values ("num_stripes", 2, 2, @num_stripes_r)
225       insert into #dump_config_table values ("retry", 3, 2, @retry_r)
226       insert into #dump_config_table values ("blocksize", 4, 2, @blocksize_r)
227       insert into #dump_config_table values ("compression", 5, 2, @compression_r)
228       insert into #dump_config_table values ("retaindays", 6, 2, @retaindays_r)
229       insert into #dump_config_table values ("init", 7, 2, @init_r)
230       insert into #dump_config_table values ("verify", 8, 2, @verify_r)
231       insert into #dump_config_table values ("notify", 9, 2, @notify_r)
232       insert into #dump_config_table values ("backup_srv_name", 10, 1, @backup_srv_name_r)
233   
234       /*
235       ** If config name is specified, but no other pars:
236       ** list this dump configuration, if doesn't exist produce error msg
237       */
238       if (@stripe_dir_r is NULL) and (@ext_api_r is NULL) and (@num_stripes_r is NULL) and (@retry_r is NULL) and (@blocksize_r is NULL) and (@compression_r is NULL) and (@retaindays_r is NULL) and (@init_r is NULL) and (@verify_r is NULL) and
239           (@notify_r is NULL) and (@backup_srv_name_r is NULL)
240       begin
241           select distinct @dmp = object_cinfo from master.dbo.sysattributes
242           where class = @DMPCFG_CLASS and object_cinfo = @config_name_r
243           if (@dmp is NULL)
244           begin
245               raiserror 17019, @config_name_r
246               return 1
247           end
248           else
249           begin
250   
251               /* Display configuration for this config name */
252               select optionname,
253                   optionvalue =
254                   case
255                       when cf.optiontype = 1 then char_value
256                       else convert(char(127), int_value)
257                   end
258               into #optioncfg
259               from #dump_config_table cf, master.dbo.sysattributes att
260               where class = @DMPCFG_CLASS and object_cinfo = @config_name_r
261                   and cf.attrib_id = att.attribute
262               if exists (select * from #optioncfg where optionname = 'init')
263               begin
264                   update #optioncfg
265                   set optionvalue =
266                       case
267                           when optionvalue = '1' then 'init'
268                           when optionvalue = '0' then 'noinit'
269                       end
270                   where optionname = 'init'
271               end
272               if exists (select * from #optioncfg where optionname = 'verify')
273               begin
274                   update #optioncfg
275                   set optionvalue =
276                       case
277                           when optionvalue = '1' then 'header'
278                           when optionvalue = '2' then 'full'
279                       end
280                   where optionname = 'verify'
281               end
282               if exists (select * from #optioncfg where optionname = 'notify')
283               begin
284                   update #optioncfg
285                   set optionvalue =
286                       case
287                           when optionvalue = '1' then 'client'
288                           when optionvalue = '2' then 'operator_console'
289                       end
290                   where optionname = 'notify'
291               end
292   
293               exec sp_autoformat #optioncfg
294               return 0
295           end
296       end
297   
298       /*
299       **  Begin a transaction. We'll be modifying rows in sysattributes
300       **  and then calling the built-in function config_admin to update config file.
301       **  If config_admin fails we'll have to rollback the changes to sysattributes.
302       **
303       */
304       begin tran dumpconfig
305   
306       /*
307       **  Check options:
308       **  if exists - update existing row in sysattributes
309       **  if not - insert the new row
310       **
311       */
312       select @CMD = 34
313       select @i = 0
314       while @i < @NUMOPTIONS /* for each option */
315       begin
316           select @attrname = optionname, @value = optionvalue, @type = optiontype, @attr = attrib_id
317           from #dump_config_table
318           where attrib_id = @i
319   
320           if (@value is NULL)
321           begin
322               select @i = @i + 1
323               continue
324           end
325           if (@type = 1)
326           begin
327               /* char option, update existing row  */
328               if exists (select *
329                       from master.dbo.sysattributes
330                       where class = @DMPCFG_CLASS and object_cinfo = @config_name_r and attribute = @i)
331               begin
332                   update master.dbo.sysattributes
333                   set char_value = @value
334                   where
335                       class = @DMPCFG_CLASS
336                       and object_cinfo = @config_name
337                       and attribute = @i
338               end
339               else
340               begin
341                   /* The option does not exists, thus insert a new row. */
342                   insert into master.dbo.sysattributes(
343                       class, attribute, object_type, object, object_cinfo, int_value, char_value)
344                   values (@DMPCFG_CLASS, @i, @OBJTYPE, 0, @config_name_r, NULL, @value)
345               end
346           end
347   
348           if (@attr in (7, 8, 9))
349           begin
350               select @intvalue =
351                   case
352                       when @value = 'noinit' then 0
353                       when @value = 'init' then 1
354                       when @value = 'header' then 1
355                       when @value = 'full' then 2
356                       when @value = 'client' then 1
357                       when @value = 'operator_console' then 2
358                   end
359   
360               /* integer option, update existing row */
361               if exists (select *
362                       from master.dbo.sysattributes
363                       where class = @DMPCFG_CLASS and object_cinfo = @config_name_r and attribute = @i)
364               begin
365                   update master.dbo.sysattributes
366                   set int_value = @intvalue
367                   where
368                       class = @DMPCFG_CLASS
369                       and object_cinfo = @config_name_r
370                       and attribute = @i
371               end
372               else
373               begin
374                   insert into master.dbo.sysattributes(
375                       class, attribute, object_type, object, object_cinfo, int_value, char_value)
376                   values (@DMPCFG_CLASS, @i, @OBJTYPE, 0, @config_name_r, @intvalue, NULL)
377               end
378           end
379           if ((@type = 2) and (@attr not in (7, 8, 9)))
380           begin
381               /* integer option, update existing row */
382               select @intvalue = convert(int, @value)
383               if exists (select *
384                       from master.dbo.sysattributes
385                       where class = @DMPCFG_CLASS and object_cinfo = @config_name_r and attribute = @i)
386               begin
387                   update master.dbo.sysattributes
388                   set int_value = @intvalue
389                   where
390                       class = @DMPCFG_CLASS
391                       and object_cinfo = @config_name_r
392                       and attribute = @i
393               end
394               else
395               begin
396                   insert into master.dbo.sysattributes(
397                       class, attribute, object_type, object, object_cinfo, int_value, char_value)
398                   values (@DMPCFG_CLASS, @i, @OBJTYPE, 0, @config_name_r, @intvalue, NULL)
399               end
400           end
401           select @i = @i + 1
402       end
403   
404   mgr:
405       select @retstat = config_admin(@CMD, 0, 0, 0, NULL, @config_name_r)
406       if @retstat = 0
407       begin
408           rollback tran dumpconfig
409           return 1
410       end
411       commit tran dumpconfig
412       return 0
413   
414   print_usage:
415       select @usage = 'sp_config_dump '
416           + '[{@config_name = ''config_name'' | ''help''}]'
417           + '[, {@stripe_dir = ''stripe_dir'' | ''delete''}]'
418           + '[, @ext_api = ''external api name'']'
419           + '[, @num_stripes = ''number of stripes'']'
420           + '[, @retry = ''number of retries'']'
421           + '[, @blocksize = ''blocksize'']'
422           + '[, @compression = ''compression level'']'
423           + '[, @retaindays = ''number of retain days'']'
424           + '[, @init = {''init'' | ''noinit''}]'
425           + '[, @verify = {''header'' | ''full''}]'
426           + '[, @notify = {''client'' | ''operator_console''}]'
427           + '[, @backup_srv_name = ''backup server name'']'
428       print @usage
429       return 0
430   


exec sp_procxmode 'sp_config_dump', 'AnyMode'
go

Grant Execute on sp_config_dump to public
go
DEFECTS
 MRIT 5 Return in Transaction trancount is 1 180
 MRIT 5 Return in Transaction trancount is 1 246
 MRIT 5 Return in Transaction trancount is 1 294
 MRIT 5 Return in Transaction trancount is 1 412
 MRIT 5 Return in Transaction trancount is 1 429
 MCTR 4 Conditional Begin Tran or Commit Tran 154
 MINU 4 Unique Index with nullable columns master..sysattributes master..sysattributes
 MTYP 4 Assignment type mismatch attribute: smallint = int 344
 MTYP 4 Assignment type mismatch class: smallint = int 344
 MTYP 4 Assignment type mismatch attribute: smallint = int 376
 MTYP 4 Assignment type mismatch class: smallint = int 376
 MTYP 4 Assignment type mismatch attribute: smallint = int 398
 MTYP 4 Assignment type mismatch class: smallint = int 398
 MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: parameter # 1 179
 MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: parameter # 1 293
 QPUI 4 Join or Sarg with Un-Rooted Partial Index Use JOIN Candidate index: sysattributes.csysattributes unique clustered
(class, attribute, object_type, object, object_info1, object_info2, object_info3, object_cinfo)
Intersection: {attribute}
Uncovered: [object_type, object, object_info1, object_info2, object_info3]
261
 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 166
 QTYP 4 Comparison type mismatch smallint = int 166
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 178
 QTYP 4 Comparison type mismatch smallint = int 178
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 242
 QTYP 4 Comparison type mismatch smallint = int 242
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 260
 QTYP 4 Comparison type mismatch smallint = int 260
 QTYP 4 Comparison type mismatch Comparison type mismatch: int vs smallint 261
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 330
 QTYP 4 Comparison type mismatch smallint = int 330
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 335
 QTYP 4 Comparison type mismatch smallint = int 335
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 337
 QTYP 4 Comparison type mismatch smallint = int 337
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 363
 QTYP 4 Comparison type mismatch smallint = int 363
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 368
 QTYP 4 Comparison type mismatch smallint = int 368
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 370
 QTYP 4 Comparison type mismatch smallint = int 370
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 385
 QTYP 4 Comparison type mismatch smallint = int 385
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 390
 QTYP 4 Comparison type mismatch smallint = int 390
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 392
 QTYP 4 Comparison type mismatch smallint = int 392
 MGTP 3 Grant to public master..sysattributes  
 MGTP 3 Grant to public sybsystemprocs..sp_config_dump  
 MLCH 3 Char type with length>30 char(127) 256
 MNER 3 No Error Check should check @@error after delete 165
 MNER 3 No Error Check should check @@error after select into 176
 MNER 3 No Error Check should check return value of exec 179
 MNER 3 No Error Check should check @@error after insert 222
 MNER 3 No Error Check should check @@error after insert 223
 MNER 3 No Error Check should check @@error after insert 224
 MNER 3 No Error Check should check @@error after insert 225
 MNER 3 No Error Check should check @@error after insert 226
 MNER 3 No Error Check should check @@error after insert 227
 MNER 3 No Error Check should check @@error after insert 228
 MNER 3 No Error Check should check @@error after insert 229
 MNER 3 No Error Check should check @@error after insert 230
 MNER 3 No Error Check should check @@error after insert 231
 MNER 3 No Error Check should check @@error after insert 232
 MNER 3 No Error Check should check @@error after select into 252
 MNER 3 No Error Check should check @@error after update 264
 MNER 3 No Error Check should check @@error after update 274
 MNER 3 No Error Check should check @@error after update 284
 MNER 3 No Error Check should check return value of exec 293
 MNER 3 No Error Check should check @@error after update 332
 MNER 3 No Error Check should check @@error after insert 342
 MNER 3 No Error Check should check @@error after update 365
 MNER 3 No Error Check should check @@error after insert 374
 MNER 3 No Error Check should check @@error after update 387
 MNER 3 No Error Check should check @@error after insert 396
 MUBC 3 Unbalanced begin tran/commit tran 411
 MUCO 3 Useless Code Useless Brackets 103
 MUCO 3 Useless Code Useless Brackets 105
 MUCO 3 Useless Code Useless Brackets 110
 MUCO 3 Useless Code Useless Brackets 123
 MUCO 3 Useless Code Useless Brackets 128
 MUCO 3 Useless Code Useless Brackets 137
 MUCO 3 Useless Code Useless Brackets 144
 MUCO 3 Useless Code Useless Brackets 152
 MUCO 3 Useless Code Useless Brackets 174
 MUCO 3 Useless Code Useless Brackets 185
 MUCO 3 Useless Code Useless Brackets 216
 MUCO 3 Useless Code Useless Brackets 243
 MUCO 3 Useless Code Useless Brackets 320
 MUCO 3 Useless Code Useless Brackets 325
 MUCO 3 Useless Code Useless Brackets 348
 MUCO 3 Useless Code Useless Brackets 379
 MUIN 3 Column created using implicit nullability 220
 QAFM 3 Var Assignment from potentially many rows 241
 QAFM 3 Var Assignment from potentially many rows 316
 QCTC 3 Conditional Table Creation 176
 QCTC 3 Conditional Table Creation 252
 QGWO 3 Group by/Distinct/Union without order by 176
 QGWO 3 Group by/Distinct/Union without order by 241
 QISO 3 Set isolation level 81
 QIWC 3 Insert with not all columns specified missing 8 columns out of 15 343
 QIWC 3 Insert with not all columns specified missing 8 columns out of 15 375
 QIWC 3 Insert with not all columns specified missing 8 columns out of 15 397
 QNAJ 3 Not using ANSI Inner Join 259
 QNUA 3 Should use Alias: Column optionname should use alias cf 252
 QNUA 3 Should use Alias: Column char_value should use alias att 255
 QNUA 3 Should use Alias: Column int_value should use alias att 256
 QNUA 3 Should use Alias: Column class should use alias att 260
 QNUA 3 Should use Alias: Column object_cinfo should use alias att 260
 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: {class, object_cinfo}
156
 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: {class, object_cinfo}
166
 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: {class}
178
 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: {class, object_cinfo}
242
 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: {class, attribute, object_cinfo}
330
 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: {class, attribute, object_cinfo}
335
 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: {class, attribute, object_cinfo}
363
 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: {class, attribute, object_cinfo}
368
 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: {class, attribute, object_cinfo}
385
 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: {class, attribute, object_cinfo}
390
 VNRD 3 Variable is not read @MAXRETRY 71
 VNRD 3 Variable is not read @gp_enabled 108
 VNRD 3 Variable is not read @dummy 135
 VUNU 3 Variable is not used @charvalue 48
 VUNU 3 Variable is not used @tempblocksize 50
 VUNU 3 Variable is not used @has_sa_role 53
 MSUB 2 Subquery Marker 155
 MSUB 2 Subquery Marker 262
 MSUB 2 Subquery Marker 272
 MSUB 2 Subquery Marker 282
 MSUB 2 Subquery Marker 328
 MSUB 2 Subquery Marker 361
 MSUB 2 Subquery Marker 383
 MTR1 2 Metrics: Comments Ratio Comments: 21% 11
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 42 = 50dec - 10exi + 2 11
 MTR3 2 Metrics: Query Complexity Complexity: 280 11

DATA PROPAGATION detailed
ColumnWritten To
@backup_srv_namesysattributes.object   °.object_info1   °.object_info3   °.int_value   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value  
°.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id °.Recovery Order sp_dbrecovery_order_rset_002.Recovery Order sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Objid °.Object °.status sp_forceonline_object_rset_002.Objid °.Object
°.status sp_forceonline_page_rset_001.Pageid °.status sp_forceonline_page_rset_002.Pageid °.status sp_listsuspect_object_rset_001.Objid °.Object °.Access sp_listsuspect_page_rset_001.Pageid °.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 °.host_port sp_setsuspect_error_rset_001.Error Num
sp_setsuspect_error_rset_002.Error Num sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cur. Suspect threshold sp_setsuspect_threshold_rset_002.Cur. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@blocksizesysattributes.object   °.object_info1   °.object_info3   °.int_value   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value  
°.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id °.Recovery Order sp_dbrecovery_order_rset_002.Recovery Order sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Objid °.Object °.status sp_forceonline_object_rset_002.Objid °.Object
°.status sp_forceonline_page_rset_001.Pageid °.status sp_forceonline_page_rset_002.Pageid °.status sp_listsuspect_object_rset_001.Objid °.Object °.Access sp_listsuspect_page_rset_001.Pageid °.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 °.host_port sp_setsuspect_error_rset_001.Error Num
sp_setsuspect_error_rset_002.Error Num sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cur. Suspect threshold sp_setsuspect_threshold_rset_002.Cur. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@compressionsysattributes.object   °.object_info1   °.object_info3   °.int_value   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value  
°.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id °.Recovery Order sp_dbrecovery_order_rset_002.Recovery Order sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Objid °.Object °.status sp_forceonline_object_rset_002.Objid °.Object
°.status sp_forceonline_page_rset_001.Pageid °.status sp_forceonline_page_rset_002.Pageid °.status sp_listsuspect_object_rset_001.Objid °.Object °.Access sp_listsuspect_page_rset_001.Pageid °.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 °.host_port sp_setsuspect_error_rset_001.Error Num
sp_setsuspect_error_rset_002.Error Num sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cur. Suspect threshold sp_setsuspect_threshold_rset_002.Cur. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@config_namesysattributes.object_cinfo   sp_optgoal_rset_002.name sp_passwordpolicy_rset_001.value sp_rjs_retrieve_rset_001.js_server
@ext_apisysattributes.object   °.object_info1   °.object_info3   °.int_value   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value  
°.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id °.Recovery Order sp_dbrecovery_order_rset_002.Recovery Order sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Objid °.Object °.status sp_forceonline_object_rset_002.Objid °.Object
°.status sp_forceonline_page_rset_001.Pageid °.status sp_forceonline_page_rset_002.Pageid °.status sp_listsuspect_object_rset_001.Objid °.Object °.Access sp_listsuspect_page_rset_001.Pageid °.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 °.host_port sp_setsuspect_error_rset_001.Error Num
sp_setsuspect_error_rset_002.Error Num sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cur. Suspect threshold sp_setsuspect_threshold_rset_002.Cur. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@initsysattributes.object   °.object_info1   °.object_info3   °.int_value   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value  
°.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id °.Recovery Order sp_dbrecovery_order_rset_002.Recovery Order sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Objid °.Object °.status sp_forceonline_object_rset_002.Objid °.Object
°.status sp_forceonline_page_rset_001.Pageid °.status sp_forceonline_page_rset_002.Pageid °.status sp_listsuspect_object_rset_001.Objid °.Object °.Access sp_listsuspect_page_rset_001.Pageid °.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 °.host_port sp_setsuspect_error_rset_001.Error Num
sp_setsuspect_error_rset_002.Error Num sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cur. Suspect threshold sp_setsuspect_threshold_rset_002.Cur. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@notifysysattributes.object   °.object_info1   °.object_info3   °.int_value   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value  
°.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id °.Recovery Order sp_dbrecovery_order_rset_002.Recovery Order sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Objid °.Object °.status sp_forceonline_object_rset_002.Objid °.Object
°.status sp_forceonline_page_rset_001.Pageid °.status sp_forceonline_page_rset_002.Pageid °.status sp_listsuspect_object_rset_001.Objid °.Object °.Access sp_listsuspect_page_rset_001.Pageid °.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 °.host_port sp_setsuspect_error_rset_001.Error Num
sp_setsuspect_error_rset_002.Error Num sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cur. Suspect threshold sp_setsuspect_threshold_rset_002.Cur. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@num_stripessysattributes.object   °.object_info1   °.object_info3   °.int_value   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value  
°.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id °.Recovery Order sp_dbrecovery_order_rset_002.Recovery Order sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Objid °.Object °.status sp_forceonline_object_rset_002.Objid °.Object
°.status sp_forceonline_page_rset_001.Pageid °.status sp_forceonline_page_rset_002.Pageid °.status sp_listsuspect_object_rset_001.Objid °.Object °.Access sp_listsuspect_page_rset_001.Pageid °.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 °.host_port sp_setsuspect_error_rset_001.Error Num
sp_setsuspect_error_rset_002.Error Num sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cur. Suspect threshold sp_setsuspect_threshold_rset_002.Cur. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@retaindayssysattributes.object   °.object_info1   °.object_info3   °.int_value   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value  
°.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id °.Recovery Order sp_dbrecovery_order_rset_002.Recovery Order sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Objid °.Object °.status sp_forceonline_object_rset_002.Objid °.Object
°.status sp_forceonline_page_rset_001.Pageid °.status sp_forceonline_page_rset_002.Pageid °.status sp_listsuspect_object_rset_001.Objid °.Object °.Access sp_listsuspect_page_rset_001.Pageid °.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 °.host_port sp_setsuspect_error_rset_001.Error Num
sp_setsuspect_error_rset_002.Error Num sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cur. Suspect threshold sp_setsuspect_threshold_rset_002.Cur. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@retrysysattributes.object   °.object_info1   °.object_info3   °.int_value   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value  
°.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id °.Recovery Order sp_dbrecovery_order_rset_002.Recovery Order sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Objid °.Object °.status sp_forceonline_object_rset_002.Objid °.Object
°.status sp_forceonline_page_rset_001.Pageid °.status sp_forceonline_page_rset_002.Pageid °.status sp_listsuspect_object_rset_001.Objid °.Object °.Access sp_listsuspect_page_rset_001.Pageid °.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 °.host_port sp_setsuspect_error_rset_001.Error Num
sp_setsuspect_error_rset_002.Error Num sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cur. Suspect threshold sp_setsuspect_threshold_rset_002.Cur. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@stripe_dirsysattributes.object   °.object_info1   °.object_info3   °.int_value   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value  
°.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id °.Recovery Order sp_dbrecovery_order_rset_002.Recovery Order sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Objid °.Object °.status sp_forceonline_object_rset_002.Objid °.Object
°.status sp_forceonline_page_rset_001.Pageid °.status sp_forceonline_page_rset_002.Pageid °.status sp_listsuspect_object_rset_001.Objid °.Object °.Access sp_listsuspect_page_rset_001.Pageid °.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 °.host_port sp_setsuspect_error_rset_001.Error Num
sp_setsuspect_error_rset_002.Error Num sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cur. Suspect threshold sp_setsuspect_threshold_rset_002.Cur. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
@verifysysattributes.object   °.object_info1   °.object_info3   °.int_value   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value  
°.char_value   sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id °.Recovery Order sp_dbrecovery_order_rset_002.Recovery Order sp_displayroles_rset_001.Role Name
sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Objid °.Object °.status sp_forceonline_object_rset_002.Objid °.Object
°.status sp_forceonline_page_rset_001.Pageid °.status sp_forceonline_page_rset_002.Pageid °.status sp_listsuspect_object_rset_001.Objid °.Object °.Access sp_listsuspect_page_rset_001.Pageid °.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 °.host_port sp_setsuspect_error_rset_001.Error Num
sp_setsuspect_error_rset_002.Error Num sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cur. Suspect threshold sp_setsuspect_threshold_rset_002.Cur. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference

DEPENDENCIES
PROCS AND TABLES USED
read_writes table tempdb..#optioncfg (1) 
read_writes table master..sysattributes (1)  
writes table tempdb..#dumpcfgname (1) 
calls proc sybsystemprocs..sp_autoformat  
   writes table sybsystemprocs..sp_autoformat_rset_002 
   reads table tempdb..systypes (1)  
   reads table master..systypes (1)  
   calls proc sybsystemprocs..sp_autoformat  
   writes table sybsystemprocs..sp_autoformat_rset_003 
   reads table tempdb..syscolumns (1)  
   writes table sybsystemprocs..sp_autoformat_rset_001 
   reads table master..syscolumns (1)  
   writes table sybsystemprocs..sp_autoformat_rset_004 
   calls proc sybsystemprocs..sp_namecrack  
   writes table sybsystemprocs..sp_autoformat_rset_005 
   read_writes table tempdb..#colinfo_af (1) 
read_writes table tempdb..#dump_config_table (1) 
calls proc sybsystemprocs..sp_aux_checkroleperm  
   reads table master..sysconfigures (1)  
   reads table master..syscurconfigs (1)  

CALLERS
called by proc sybsystemprocs..sp_downgrade_dump_config