Skip to content
  • Home
  • SteamDeck
  • Linux
  • SQL-Server
  • PowerShell
  • Oracle
Schelstraete.orgSchelstraete.org
SCHELSTRAETE.ORG

I.T. minded

  • Home
  • SteamDeck
  • Linux
  • SQL-Server
  • PowerShell
  • Oracle
LinkedIn Email
Schelstraete.orgSchelstraete.org
SCHELSTRAETE.ORG

I.T. minded

T-SQL: Check number of messages in distribution

  • BartBart
  • September 1, 2021
  • Uncategorized

With this command you can check the amount of transactions in the distribution database

 SELECT count(*) 
  FROM [distribution].[dbo].[MSrepl_transactions]
  where entry_time > '2021-08-31 06:00:00.00' and entry_time < '2021-08-31 13:35:09.880'
Share your love
Bart
Bart
Articles: 100
T-SQL-Commands
Previous Post T-SQL: Kill all inactive sessions from specific user
Next Post Strongswan: Dynamic (BGP) IPsec VPN tunnel with strongSwan
No results

Recent Posts

  • Steam Deck: Hogwarts Legacy performance
  • T-SQL: Check cpu usage SQL statements
  • Steam Deck: Transfer files from Windows to Deck
  • PowerShell: Check TLS version
  • T-SQL: Identify queries that consume a large amount of log space

Archives

  • February 2023
  • December 2022
  • January 2022
  • December 2021
  • October 2021
  • September 2021
  • July 2020
  • March 2020
  • February 2020
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • February 2019
  • November 2017
  • August 2017
  • July 2017
  • June 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016

Categories

  • Avamar
  • General
  • Ispconfig
  • Linux
  • Oracle
  • PowerShell
  • SAP Hana
  • SQL-Server
  • SteamDeck
  • Uncategorized
Related Articles
T-SQL-Commands

T-SQL: Give views permissions to all stored procedures

  • Bart
  • May 15, 2019

Copyright © 2023 Schelstraete.org

Add Schelstraete.org as app.

ADD