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

1     
2     
3     /* Sccsid = "%Z% generic/sproc/%M% %I% %G%" */
4     
5     create procedure sp_oledb_databases(@database_name varchar(32) = null)
6     as
7         if @@trancount = 0
8         begin
9             set chained off
10        end
11    
12        set transaction isolation level 1
13    
14        if @database_name is null
15        begin
16            select CATALOG_NAME = name,
17                DESCRIPTION = convert(varchar(254), null) /*no description*/
18            from master.dbo.sysdatabases order by name
19        end
20        else
21        begin
22            select CATALOG_NAME = name,
23                DESCRIPTION = convert(varchar(254), null) /*no description*/
24            from master.dbo.sysdatabases where name = @database_name
25            order by name
26        end
27    
28        return (0)
29    

exec sp_procxmode 'sp_oledb_databases', 'AnyMode'
go

Grant Execute on sp_oledb_databases to public
go

DEFECTS
MGTP 3 Grant to public master..sysdatabases
MGTP 3 Grant to public sybsystemprocs..sp_oledb_databases
MUCO 3 Useless Code Useless Brackets in create proc	5
MUCO 3 Useless Code Useless Brackets	28
QCRS 3 Conditional Result Set	16
QCRS 3 Conditional Result Set	22
QISO 3 Set isolation level	12
MRST 2 Result Set Marker	16
MRST 2 Result Set Marker	22
MTR1 2 Metrics: Comments Ratio Comments: 9%	5
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 2dec - 1exi + 2	5
MTR3 2 Metrics: Query Complexity Complexity: 13	5

DEPENDENCIES

PROCS AND TABLES USED reads table master..sysdatabases (1)