create procedure sys.sp_catalogs_rowset2
as
-------------------------------------------------------------------------------------------
-- copy & pasted from version 1 of the SProc and removed checks for 1st parameter !
-------------------------------------------------------------------------------------------
select
CATALOG_NAME = name,
DESCRIPTION = convert(nvarchar(1),null)
from
sys.databases
where
has_dbaccess(name)=1
order by 1
|