Are You Running SQL 2000 And A Yukon CTP Side By Side?
If you are, you might have noticed a couple of problems when your'e working with old school (read: SQL 2000) stuff. I haven't really played that much with Yukon myself, so I'm definitely no expert. But my ex-team leader has, and he's noticed a couple of problems - in both the April and June CTP's, and it's not just him (I've noticed the problem on my box in the little playing I've done, and other people in newsgroups he's talked to have seen it as well).
The first problem is annoying. In Enterprise Manager, whenever you right click on a database and select 'Properties' Enterprise Manager would crash. The second one is just weird - Query Analyzer loses it's syntax highlighting.
To fix both these issues, it's quite simple. There's three dll's that need to be re-registered - I guess the CTP installs are tromping on some ProgID somewhere. Open a cammand prompt and make your way to 'C:\Program Files\Microsoft SQL Server\80\Tools\Binn\'. then run these:
- regsvr32 sqldmo.dll
- regsvr32 sqlmmc.dll
- regsvr32 sqlex.dll
The first two fix the crash in enterprise manager, the last the syntax highlighting. Actually, we've got no idea about sqlmmc.dll. Someone recommended including that one, but no explanation as to why. Oh well :)
Listening to: bug bites - alien ant farm - (3:23)