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:

    Monthly Archives: July 2020

    1. Home  - 2020  - 
    2. July
    30 Jul, 2020
    Sybase Replication Thread down issue:Foreign key constraint violation occurred 0 (0)
    Sybase Replication #foreign key constraint, #sybase replication

    Error Code Description: Message: 546, State 1, Severity 16 — 'Foreign key constraint violation occurred, dbname = 'db2', table name = 'table1', constraint name = 'constraint1'

    Cause:This issue occurs when data inserted into a foreign key does not … Read the rest

    30 Jul, 2020
    Sybase Replication Thread down issue: Trigger Disabled 0 (0)
    Sybase Replication Sybase, trigger

    Error Code Description: Message: 4986, State 1, Severity 10 — 'Warning: trigger 'TestTrigger' is already disabled.

    Cause: This issue occurs when someone tries to disable a trigger on production database table and then warm standby replication tries to … Read the rest

    30 Jul, 2020
    How to check if windows machine is physical or Virtual 0 (0)
    MSSQL

    Method 1:


    For windows, Click Start → Run → open cmd prompt →  run below command

    systeminfo /s %computername% | findstr /c:"Model:" /c:"Host Name" /c:"OS Name"

    Method 2:

    Click Start → Run → open cmd prompt →  run below command

     msinfo32

    Here, System … Read the rest

    30 Jul, 2020
    What is latency in Sybase database: 0 (0)
    Sybase Replication Sybase Latency

    Latency is the time it takes for the data to replicate at the subscriber once it updates the primary.

    Reason for latency

    1. When DSI thread is down
    2. When huge batch jobs running on the primary database.
    3. When blocking at replicate
    … 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
    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