var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Is there a way to hardcode the ip address instead of the Server name in replication script? One of our server is registering 2 IP addresses for itself in DNS. One valid and one invalid. Which is causing the replication to fail.
exec sp_addsubscription @publication = N'WorkFlowtoStats_Weekly', @article = N'all', @subscriber = N'IMGSTAT01', @destination_db = N'Stats', @sync_type = N'automatic', @update_mode = N'read only', @offloadagent = 0, @dts_package_location = N'distributor'
Go to the server(s) that have problems resolving the name. Use the SQL Client configuration on that server to create a SQL alias for the offending server that points to the correct IP address.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors