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:

    Category Archives: Sybase ASE

    1. Home  - 
    2. Archive by category "Sybase ASE"
    3. ( Page3 )
    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

    9 Aug, 2020
    How to Upgrade SYBASE ASE from 12.5 to 15.7 by using Inplace Upgradation. 0 (0)
    Sybase ASE Sybase database upgrade

    Pre-Upgradation Tasks –

    1. Make sure the Unix SA's have installed the correct Package ASE 15.7
    2. Keep the srvbuild sample resource files ready for the current ASE and Backup server
    3. RUN DBCC for all the databases to make sure no database
    … 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

    2 Aug, 2020
    cannot drop user because user owns objects in database 0 (0)
    Sybase ASE #drop user, #object ownership

    Error Description:

    Msg 17545, Level 16, State 1:
    Server 'SYB_ASE', Procedure 'sp_dropuser', Line 267:
    You cannot drop user because user 'testuser' owns objects in database.

    Resolution:

    Step1: First find out uid of user

    1> select uid from sysusers where … Read the rest

    29 Jul, 2020
    Bypass recovery for Sybase ASE database 0 (0)
    Sybase ASE Sybase bypass recovery
    Case description : Bypass recovery for Sybase ASE server database.
    Cause :Database recovery failed during Sybase ASE reboot due to log full issue.
    Solution:- Perform Bypass Recovery as shown below.
    1.      Steps to perform before shutting down


    Login to the
    … Read the rest

    Posts pagination

    1 2 3
    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