2

I'm working on a script to iterate through all the snapshot folders and do some basic find and replace of the ANSI_PADDING OFF bug and replace it with SET ANSI_PADDING ON. I'd like to be able to dynamically point to any publisher and get a list of currently configured snapshot folders by publication. I can then filter and dedupe if needed.

I know I can query the distribution database for the default folder but how do I return the currently configured one, if say, someone changed the snapshot folder via the Replication Monitor GUI?

Paul White
  • 94,921
  • 30
  • 437
  • 687
Alexandar Narayan
  • 43
  • 5

1 Answers1

3

The snapshot folder is configured per Distributor. The stored procedure sp_helpdistributor returns a column directory which is the snapshot folder for a specified distributor.

Brandon Williams
  • 3,154
  • 13
  • 17