USE [DISTRIBUTION]
GO
DECLARE @result nvarchar(255)
exec sp_helpdistributor @directory = @result OUTPUT
PRINT @result
GO
SELECT value FROM ::fn_listextendedproperty('SnapshotFolder', 'user',
'dbo', 'table', 'UIProperties', null, null)
go
SELECT * FROM msdb.dbo.MSdistpublishers
GO
/*Changing SQL Server's Default Snapshot Folder for Replication*/
USE distribution
exec sp_changedistpublisher
@publisher = 'FL-WS-CON-CC03',
@property = 'working_directory',
@value = '\\FL-WS-CON-CC03\Share2'
Reference:http://www.mssqltips.com/sqlservertip/2785/changing-sql-servers-default-snapshot-folder-for-replication/