3094124 - sp_shrink does not recognize when the server is in single user mode - SAP ASE

• Issues to reduce data from sybsecurity database.
• Customer is using flat file devices. Data and log are separated
• Customer wants to know how to free data from their sybsecurity databases.
• Customer try to run sp_shrink with ASE started in single user(-m) and get error:
  
  • DBCC: checking database 'sybsecurity'.
    DBCC execution completed. If DBCC printed error messages, contact a user with
    System Administrator (SA) role.
    Msg 17435, Level 16, State 1:
    Server 'xxxx', Procedure 'sp_dboption', Line 849:
    The 'single user' option is not valid for the 'sybsecurity' database.
    (return status = 1)

• SAP NetWeaver Application Server for ABAP 7.52
• SAP Adaptive Server Enterprise 16.0 SP03 PL06 and higher.

CR825458,825458, sp_shrink,Msg 17435 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem