Source: Snapshot folder location lookup for the distribution server of SQL Server replication
SQL Serverin the distribution server configuration, you need to configure the snapshot folder (Snapshot Folder), to store the working directory of the published data and schema files, how do I find the snapshot folder location of the Distributor for the current SQL Server database server?
If you have configured specific publications and subscriptions, you can view them in the corresponding publication properties -Snapshot file, and if you haven't configured a specific publication or subscription, how do you want to view it?
Today happened to encounter such a problem, studied, in fact, these values are saved below the table msdb.dbo.MSdistpublishers, as shown below.
SELECT * from Msdb.dbo.MSdistpublishers;
Snapshot folder location lookup for the SQL server replication distribution server