Skip to content

Instantly share code, notes, and snippets.

@sayham-sjb

sayham-sjb/CountPublisherOnDB.sql

Created July 10, 2018 18:38
Show Gist options
  • Save sayham-sjb/22ebd7a123c95a8b436d0b1dabc5b72a to your computer and use it in GitHub Desktop.
Save sayham-sjb/22ebd7a123c95a8b436d0b1dabc5b72a to your computer and use it in GitHub Desktop.
Download ZIP
CountPublisherOnDB #sql
Raw
CountPublisherOnDB.sql
SELECT publisher_db, COUNT(1) FROM distribution.dbo.MSarticles
GROUP BY publisher_db
ORDER BY COUNT(1), publisher_db
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment