• Search for:

    Category Archives: MSSQL

    1. Home  - 
    2. Archive by category "MSSQL"
      3. ( Page7 )
    3 Jul, 2021
    T-SQL Script to change compatibility level of all databases in SQL Server 0 (0)
    MSSQL , ,

    declare @CompatibilityLevelUpdate varchar(255)
    set @CompatibilityLevelUpdate = "
    select @CompatibilityLevelUpdate =@CompatibilityLevelUpdate +
    'alter database [' + name + '] set compatibility_level =150;' + char(15)
    from sys.databases
    where database_id4 — exluding system databases
    exec (@CompatibilityLevelUpdate)

    — Verify compatibility level

    select name … Read the rest

    1 Jul, 2021
    T-SQL Script to restore multiple databases using backup files in SQL Server 1 (1)
    MSSQL , , ,

    Below query can be used to restore multiple SQL Server databases using backup files.

    SET NOCOUNT ON
DECLARE
@foldername Varchar (255) = 'D:\MSSQL\MSSQLSERVER', --path where .bak files are placed
@DataFileLocation Varchar(255) = 'E:\MSSQL' , -- Optional, Specifies the folder for
    … Read the rest
    19 Jun, 2021
    How to check when procedure was last executed in SQL Server 0 (0)
    MSSQL , ,

    select
    db_name() [database name]
    ,[schema name] = SCHEMA_NAME([schema_id])
    ,o.name
    ,create_date [create date]
    ,modify_date [last modify date]
    ,ps.last_execution_time
    from sys.dm_exec_procedure_stats ps
    inner join
    sys.objects o
    ON ps.object_id = o.object_id
    where o.type = 'P'
    –and o.schema_id = schema_name(schema_id)
    and o.name = 'MonTlogUsage'    … Read the rest

    13 Jun, 2021
    How to monitor SQL server transaction log usage 0 (0)
    MSSQL , , , ,

    Problem Description:

    Many a times there are requirements to monitor SQL server log usage historically and analyze when it is needed. Below are the step by step solutions.

    Solution:

    Step1: create database

    create database MonitorDB
    go

    Step 2:- … Read the rest