Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Merge publications with parameterized filters use the SUSER_SNAME() function and/or the HOST_NAME() function to filter data. The function is specified in the New Publication Wizard or the Publication Properties dialog box.
By default, the HOST_NAME() function returns the name of the computer connecting to the Publisher. When using parameterized filters, it is common to override this value by supplying a value on this page of the wizard. The HOST_NAME() function then returns the value you specify rather than the name of the computer. For more information, see the "Overriding the HOST_NAME() Value" section of Parameterized Row Filters.
Note
If you override HOST_NAME(), all calls to the HOST_NAME() function will return the value you specify. Ensure that other applications are not depending on HOST_NAME() returning the computer name.
Options
- Subscription properties
Enter a value for each Subscriber in the HOST_NAME Value column or accept the default, which is the name of the Subscriber computer.
See Also
Other Resources
How to: Create a Pull Subscription (SQL Server Management Studio)
How to: Create a Push Subscription (SQL Server Management Studio)
How to: View and Modify Pull Subscription Properties (SQL Server Management Studio)
How to: View and Modify Push Subscription Properties (SQL Server Management Studio)
HOST_NAME (Transact-SQL)
Subscribing to Publications
Replication Properties
Replication Wizards