• Search for:

    Tag Archives: sql server management studio

    1. Home  - 
    2. Posts tagged "sql server management studio"
    19 Sep, 2022
    How to read SQL Server error logs using the xp_readerrorlog 5 (1)
    MSSQL, T-SQL Scripts , , , ,

    In this article, we are going to explore xp_readerrorlog for reading SQL Server error logs using T-SQL command.

    Reading SQL Server error log using T-SQL:

    xp_readerrorlog

    xp_readerrorlog Parameters Value Details:

    xp_readerrorlog <paramter#1>,<paramter#2>,<paramter#3>,<paramter#4>,<paramter#5>,<paramter#6>,<paramter#7>

    Parameter#1:… Read the rest

    31 Aug, 2022
    SQL On Linux: CU Upgrade from CU12 to CU17 0 (0)
    MSSQL, SQL On Linux , , , ,

    Below are step by step process to upgrade Cumulative Updates(CU) in SQL Server 2019 on Linux.

    Run below query to check current SQL Server version.

    SELECT SERVERPROPERTY('productversion') 'ProductVersion', SERVERPROPERTY ('productlevel') 'ProductLevel', SERVERPROPERTY ('edition') 'Edition'

    SQL Server version/CU can be verified … Read the rest