Changes between Initial Version and Version 1 of Ticket #933, comment 2


Ignore:
Timestamp:
Dec 4, 2017, 4:11:42 AM (4 years ago)
Author:
jng

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #933, comment 2

    initial v1  
    1111
    1212{{{
    13 select name, HAS_DBACCESS(name)
     13select name
    1414 from master.dbo.sysdatabases S
    15  where databasepropertyex(name, 'Status')='ONLINE'
     15 where databasepropertyex(name, 'Status')='ONLINE' and HAS_DBACCESS(name) = 1
    1616 order by name collate latin1_general_bin asc
    1717}}}
    18 
    19 And the FDO provider should only consider rows where {{{HAS_DBACCESS(name)}}} evaluated to {{{1}}}