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 IQ

    1. Home  - 
    2. Archive by category "Sybase IQ"
    11 Sep, 2022
    SYBASE IQ: .db or .log file exists. Full restore will not be done 0 (0)
    Sybase IQ SAP, SAP IQ, Sybase IQ

    Problem Description:

    When running Sybase IQ database RESTORE, you see the following error:

    Could not execute statement.
    .db or .log file exists. Full restore will not be done.

    Problem Resolution:

    This error usually appears when either <IQDB.db> or <IQDB.log> file … Read the rest

    6 Sep, 2022
    T-SQL Query to check Sybase IQ Collation 0 (0)
    Sybase IQ Collation, Sybase IQ

    Below queries can be used to check Sybase IQ Collation.

    Query#1:

    1select * from sa_db_properties() where PropName='Collation'
    2go

    Result:

    Query#2:

    1select db_property('Collation')
    2go

    … Read the rest
    13 Aug, 2020
    SAP Sybase IQ useful commands 5 (4)
    Sybase IQ Sybase IQ useful commands
    • How to create new user in Sybase IQ
      create user <username> identified by <password> ;
      grant connect to <username> identified by <password> ;
    • How to change/reset user password in Sybase IQ
      Alter user <username> identified by <password>
    • How to check
    … 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