Skip to Content
24x7 Support
Email: mail@example.com
Call Us +(21) 1234 5678

    • Home
    • MSSQL
      • SQL On Linux
      • T-SQL Scripts
    • Sybase ASE
      • Sybase Scripts
    • Sybase Replication
    • Sybase IQ
    • Linux
    • Search for:

    Tag Archives: #sybase

    1. Home  - 
    2. Posts tagged "#sybase"
    12 Aug, 2020
    How to check if Sybase database is offline 0 (0)
    Sybase ASE #database offline, #offline, #sybase

    1Select name from sysdatabases where status2 & 48 0
    2go

    name

    —————-

    testdb

    (1 row affected)

    … Read the rest

    11 Aug, 2020
    How to check zombie process in Sybase ASE 0 (0)
    Sybase ASE #sybase, #zombie

    Zombie process is a process that shows up in syslocks but not in sysprocesses table. we need to either reboot the sybase server or use dbcc lock_release option to clear the process(to be done very carefully), else it can cause … Read the rest

    3 Aug, 2020
    You cannot drop user because user 'testuser' owns grantable privileges and granted them to other users. 0 (0)
    Sybase ASE #drop user, #sp_dropuser, #sybase

    Error Description:

    Msg 17549, Level 16, State 1:
    Server 'SYB_ASE', Procedure 'sp_dropuser', Line 3:
    You cannot drop user because user 'testuser' owns grantable privileges and granted them to other users. The user has granted the following privileges:

    Resolution:

    Step1: … Read the rest

    Recent Posts
    • SQL Server: T-SQL Script to find object level permission of specific table
    • SQL Server: T-SQL Script to find object level permission of user database
    • T-SQL Script to get user with DB OWNER role in SQL Server
    • T-SQL script to list all database user access in SQL Server
    • T-SQL script to find active processes in SQL Server

    Pages

    • About Me
    • Contact
    • Disclaimer
    • Privacy Policy

    Categories

    • Linux (8)
    • MSSQL (75)
      • SQL On Linux (15)
      • T-SQL Scripts (19)
    • Sybase ASE (26)
      • Sybase Scripts (1)
    • Sybase IQ (3)
    • Sybase Replication (27)
    • Uncategorized (1)

    Archives

    Copyright © 2025 | Powered by Neom