Fixed my SqlServer/Enterprise Manager issues

Lately SqlServer has been giving me some little headaches...

Firstly, Enterprise Manager crashes at certain times - such as when I try to view the properties of certain database object - and then attempts to send an error report to Microsoft.

Secondly, when trying to view the permissions window, it would choke and complain that: "'schema_name' is not a recognized function name" .

Finally, I was unable to run the "Generate Sql Scripts" tool as it was disabled.

It was really getting annoying. Finally I decided to poke around on Google to see whether this is a "known issue" and sure enough, it turns out that it is probably a side-effect of me having installed SQL 2005.

A quick re-register of the SqlDMO.dll and all was fixed!

 C:\ regsvr32 "C:\Program Files\...\SqlDmo.dll"