Unable to specify a remote distributor for a Des

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Unable to specify a remote distributor for a Desktop/MSDE publisher. Why?

For Desktop edition or Microsoft Data Engine, we can not specify a remote distributor. This is a restriction imposed on these editions of SQL Server.

(Continued on next question...)

Other Job Interview Questions

• None of my replication agents are starting. The error message reads: ‘The step did not generate any output. The step failed’. How to correct this problem?
• None of my replication agents are starting. The error message reads: ‘The step did not generate any output. The step failed’. How to correct this problem?
• None of my replication agents are starting. The error message reads: ‘The step did not generate any output. The step failed’. How to correct this problem?
• What is Replication Monitor and how it can be used to monitor replication activity and performance?
• A non-dbo owned table when merge replicated to the subscriber, is being owned by dbo. Is there a way to maintain table ownership in merge replication?
• Unable to specify a remote distributor for a Desktop/MSDE publisher. Why? How to start replication agents programmatically?
• Setup Transactional replication with "Immediate Updating Subscribers". Changes on publisher get replicated to the subscriber ...
• Unable to specify a remote distributor for a Desktop/MSDE publisher. Why?
• How to change the schema of a published table?
• The Snapshot and Logreader agents are running on the same publishing/distributing server, but still they are not able to connect. How to overcome this problem?
• More...