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:

    Yearly Archives: 2020

    1. Home  - 
    2. 2020
    28 Aug, 2020
    User, group, or role already exists in the current database (Microsoft SQL Server, Error: 15023). 0 (0)
    MSSQL SQL Server error 15023

    We were facing below error while trying to grant access to the database for specific login.

    Problem Description:

    Create failed for User (Microsoft.SqlServer.Smo)
    SQL Server Error User, group, or role already exists in the current database. (Microsoft SQL Server, Error:
    … Read the rest

    27 Aug, 2020
    Query to put all databases in read only mode in SQL server 0 (0)
    MSSQL SQL on Linux, SQL Server read only mode

    select 'alter database [' + name + '] set READ_ONLY WITH NO_WAIT
    go'
    from sys.databases where database_id4
    … Read the rest

    18 Aug, 2020
    How to install SQL agent on Linux platform 0 (0)
    MSSQL, SQL On Linux Enable SQL Server Agent on Linux, SQL on Linux

    Case1: if you are on SQL Server 2017 CU3 or lower one, you have to separately install SQL agent package.

    below is the steps to install the package

    sudo yum install mssql-server-agent
    sudo systemctl restart mssql-server

    in case, if … Read the rest

    17 Aug, 2020
    How to fix Sybase Error 644 5 (3)
    Sybase ASE Sybase Error 644

    Error Description:

    Error: 644, Severity: 21, State:
    server Index row entry for data row id (1234, 0) is missing from index page 5678 of index id 3 of table 'test' in database 'TestDB'. Xactid is (123456,30). Drop and re-create … Read the rest

    16 Aug, 2020
    SAP Sybase Replication server installation : Step by Step 5 (1)
    Sybase Replication Sybase Replication Server Installation

    Prerequisite:

    Please ensure that Replication server binary is already installed on the host.

    Installation Step:

    cd ${REP}/install
    run ./rs_init to initiate the Replication installation

    1. Release directory: /directory_path/rs1571 <———– This is Replication server binary install directory
    2. Configure a Server product <———–
    … Read the rest
    15 Aug, 2020
    Replicate Minimal Column in Sybase Replication 0 (0)
    Sybase Replication Sybase Replication Minimal column

    Replicate minimal column property plays important role in Sybase replication performance. if this property is not defined within replication definition, replication server will replicate all columns for a modified row, even those values that have not been modified, thus it … Read the rest

    15 Aug, 2020
    Sybase tempdb binding 0 (0)
    Sybase ASE #Sybase tempdb binding

    In high OLTP nature environment we have seen many times that tempdb gets full due to bad query run by the user and it affects entire server as tempb is common area for sorting user data in the database server.… Read the rest

    15 Aug, 2020
    Sybase tempdb 100% full 0 (0)
    Sybase ASE Sybase tempdb 100% full

    Error Description:

    Failed to allocate disk space for a work table in database 'tempdb'.  You may be able to free up space by using the DUMP TRANsaction command, or you may want to extend the size of the database by … Read the rest

    15 Aug, 2020
    Query to check autocorrection property on RSSD 0 (0)
    Sybase Replication Sybase autocorrection

    Login to RSSD Dataserver and run below command

    1use SYB_RSSD
    2go

    3>SELECT obj.objname AS RepDef
    , db.dsname replicate_dataserver
    , db.dbname replicate_database
    , 'Yes' AS AutoCorrectionEnabled
    FROM rs_repobjs repobj
    JOIN rs_objects obj ON ((repobj.attributes & 0x1) = 0x1 AND

    … Read the rest
    15 Aug, 2020
    Autocorrection in SAP Sybase ASE 0 (0)
    Sybase Replication Sybase autocorrection
    • Autocorrection can be used to bring up the replication server when it is down due to duplicate insert error and mostly used when number of transaction records captured in exception log are more.
    • When autocorrection is on, Replication Server converts each update
    … Read the rest

    Posts pagination

    1 2 … 4
    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