Wednesday, December 19, 2007

MMC Snap-in error in SQL 2000

Problem:
I get an error from SQL 2000 Enterprise Manager's MMC Console when I right-click on database properties for any database shown in the Enterprise Manager list, and Enterprise Manager freezes requiring me to close it and re-launch it.

Possible reason:
Only one SQL DMO dll can exist on the server and it has been replaced by the new SQL2005 version.

Solution:
Re-register sqldmo.dll fom the SQL Server 2000 directory.

regsvr32 "c:\program files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll"

No comments: