T-SQL: Check number of messages in distribution
With this command you can check the amount of transactions in the distribution database
SCHELSTRAETE.ORG
I.T. minded
Uncategorized
Read More
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…