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
SCHELSTRAETE.ORG
I.T. minded
Category Uncategorized
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…