Monday, 5 August 2013

Changing SQL Server's Default Snapshot Folder for Replication

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/


No comments:

Post a Comment