DatabaseProcApplicationCreatedLinks
sybsystemprocssp_who  14 d├ęc. 14Defects Propagation Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/%M% %I% %G%" */
3     /*	4.8	1.1	06/14/90	sproc/src/serveroption */
4     
5     /*
6     ** Messages for "sp_who"		17nnn
7     ** 
8     ** 17231, "No login with the specified name exists." 
9     */
10    
11    create or replace procedure sp_who @loginame varchar(255) = NULL as
12    
13        declare @low int
14        declare @high int
15        declare @spidlow int
16        declare @spidhigh int
17        declare @len1 int, @len2 int, @len3 int
18        declare @kernel_mode varchar(15)
19    
20        if @@trancount = 0
21        begin
22            set chained off
23        end
24    
25        set transaction isolation level 1
26    
27        select @kernel_mode = @@kernelmode
28    
29        select @low = @@minsuid, @high = @@maxsuid,
30            @spidlow = @@minspid, @spidhigh = @@maxspid
31    
32        if @loginame is not NULL
33        begin
34            select @low = suser_id(@loginame), @high = suser_id(@loginame)
35            if @low is NULL
36            begin
37                if @loginame like "[0-9]%"
38                begin
39                    select @spidlow = convert(int, @loginame),
40                        @spidhigh = convert(int, @loginame),
41                        @low = @@minsuid, @high = @@maxsuid
42                end
43                else
44                begin
45                    /*
46                    ** 17231, "No login with the specified name exists." 
47                    */
48                    raiserror 17231
49                    return (1)
50                end
51            end
52        end
53    
54        select fid, spid, status, loginame = suser_name(suid),
55            origname = isnull(suser_name(origsuid), suser_name(suid)), hostname,
56            blk_spid = blocked, dbname = db_name(dbid),
57            tempdbname = db_name(tempdb_id(spid)), cmd, block_xloid, affinity
58        into #who1result
59        from master..sysprocesses
60        where suid >= @low and suid <= @high
61            and spid >= @spidlow and spid <= @spidhigh
62    
63        if (@kernel_mode = 'process')
64        begin
65            exec sp_autoformat @fulltabname = #who1result,
66                @selectlist = "fid, spid, status, loginame, origname, hostname, blk_spid, dbname, tempdbname, cmd, block_xloid",
67                @orderby = "order by fid, spid, dbname"
68        end
69        else
70        begin
71            exec sp_autoformat @fulltabname = #who1result,
72                @selectlist = "fid, spid, status, loginame, origname, hostname, blk_spid, dbname, tempdbname, cmd, block_xloid, threadpool = affinity",
73                @orderby = "order by fid, spid, dbname"
74        end
75    
76    
77        drop table #who1result
78    
79    
80        return (0)
81    
82    


exec sp_procxmode 'sp_who', 'AnyMode'
go

Grant Execute on sp_who to public
go
DEFECTS
 MTYP 4 Assignment type mismatch @kernel_mode: varchar(15) = int 27
 MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname 65
 MUSP 4 Unquoted String Parameter sybsystemprocs..sp_autoformat: @fulltabname 71
 QTYP 4 Comparison type mismatch Comparison type mismatch: smallint vs int 61
 TNOI 4 Table with no index master..sysprocesses master..sysprocesses
 MGTP 3 Grant to public master..sysprocesses  
 MGTP 3 Grant to public sybsystemprocs..sp_who  
 MNER 3 No Error Check should check @@error after select into 54
 MNER 3 No Error Check should check return value of exec 65
 MNER 3 No Error Check should check return value of exec 71
 MUCO 3 Useless Code Useless Brackets 49
 MUCO 3 Useless Code Useless Brackets 63
 MUCO 3 Useless Code Useless Brackets 80
 QISO 3 Set isolation level 25
 VUNU 3 Variable is not used @len1 17
 VUNU 3 Variable is not used @len2 17
 VUNU 3 Variable is not used @len3 17
 MTR1 2 Metrics: Comments Ratio Comments: 11% 11
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 9 = 9dec - 2exi + 2 11
 MTR3 2 Metrics: Query Complexity Complexity: 36 11

DEPENDENCIES
PROCS AND TABLES USED
writes table tempdb..#who1result (1) 
reads table master..sysprocesses (1)  
calls proc sybsystemprocs..sp_autoformat  
   reads table master..systypes (1)  
   writes table sybsystemprocs..sp_autoformat_rset_001 
   writes table sybsystemprocs..sp_autoformat_rset_004 
   writes table sybsystemprocs..sp_autoformat_rset_002 
   reads table tempdb..systypes (1)  
   reads table master..syscolumns (1)  
   read_writes table tempdb..#colinfo_af (1) 
   writes table sybsystemprocs..sp_autoformat_rset_005 
   writes table sybsystemprocs..sp_autoformat_rset_003 
   calls proc sybsystemprocs..sp_namecrack  
   calls proc sybsystemprocs..sp_autoformat  
   reads table tempdb..syscolumns (1)