IT Errors and Solutions Blog

Windows XP SP, Outlook 2003

User was getting error message “One or more activex controls could not be displayed…”.

It is 2 ways to resolve this issue.

1) Check checkbox for “Use Microsoft Office Word 2003 to edit messages” in Outlook’s Tool >> Options >> Mail Format

2)If you don’t want to use Word.

Go to

C:\Documents and Settings\user_name\Application Data\Microsoft\Signatures

Make sure you make a copy of the *.htm signature.

Open htm signature in notepad.

Search for tag <object>.

Delete everything between <object></object> tags, including tags.

Save document. The problem is solved.

Additional resources:

Microsoft Outlook 2003
Microsoft Outlook 2007

To remove replication on database NorthWind

 sp_removedbreplication ‘NorthWind’

Error:
Msg 208, Level 16, State 1, Procedure sp_get_distributor, Line 108
Invalid object name ‘msdb.dbo.MSdistributiondbs’.

Resolution:

I got call from my client and…
I’m not sure what originally happened to replication setup, replication database was in very bad shape, SQL Server was reproducing many errors. I spent hours searching for solutions on internet and Microsoft and was able to find few related articles and resolutions, but nothing did work. It was badly damaged. Distribution database in system tables was damaged and not accessible and stored procedures required for replications in msdb database were missing. It was impossible either to recover or restore.

What I had to do is to create another instance on the server, enable replications on a new instance.

Stop both SQL Server instances on a server. Copy and move distribution and msdb system databases from a new healthy instance over existing files for default instance.

Then started default instance server and agent and it did a trick. The new instance is shutdown, no need to run.

Window Server 2003 (64) and SQL Server 2005 (64)

Error:
The replication agent had encountered an exception.
Source: Replication
Source: Replication
Microsoft.SqlServer.Replication.ReplicationAgentException
Exception Message: The snapshot could not be generated because the publisher is inactive.
Message Code: 54057

Resolution:

Disable publishing and distribution on Replication folder.
Re-create replication, did the trick