None of you replication wizards are coming up. E

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

(Continued from previous question...)

None of you replication wizards are coming up. Enterprise Manager lets you click on the replicaiton options, but nothing happens. What's wrong?

Most probable reason for this behavior could be that you have de-selected the 'Replication Support' option while installing SQL Server. Try the following steps to fix this problem

- Start Setup
- Choose custom install
- Check 'Replication Support' under 'Server Components'
- Complete the setup

(Continued on next question...)

Other Job Interview Questions

• How to find out whether a change to the data is made by replication or by other users/applications?
• How to change the schema of a published table?
• How to maintain IDENTITY property of a column on both publishing and subscribing databases in transactional replication?
• How to subscribe with ‘NOSYNC’ to a transactional publication?
• None of you replication wizards are coming up. Enterprise Manager lets you click on the replicaiton options, but nothing happens. What's wrong?
• Merge agent is failing with the error: 'The process could not initialize "database reconciler". Check to see if the component is registered correctly’. Where to look?
• Replication agents are failing with the following error. What's wrong?
• 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?
• What is Replication Monitor and how it can be used to monitor replication activity and performance?
• Unable to drop a table even after removing replication. Getting the following errors, when try to drop or alter the table...
• More...