T-SQL: Check number of messages in distribution
With this command you can check the amount of transactions in the distribution database
0109, 2021
1505, 2019
T-SQL: Give views permissions to all stored procedures
You can use the T-SQL code below within your database to give permissions to ‘MYUSER’ for viewing all stored procedures. (of course, replace “MYUSER” with your own user) Once executed, you can copy and paste the output to a new query window an execute it.