Enterprise Manager can't get database properties

Hi again!
On my previous question I got no answers or any help,
yet it is for me great problem.
I can't get DB properties from any DB on any
instance of three installed. EM shut itself down instead,
without any warning or error message.
I need to change some data types and collation settings.
Any help (desperately needed) would be appreciated!
Peter
Message posted via http://www.sqlmonster.com
Sounds like you might need to reregister SQL-DMO. From a command prompt run
the following and see if that helps
regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll"
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Peter K. via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:4ef1c47f4a7f460b9dcc1ddf45893888@.SQLMonster.c om...
> Hi again!
> On my previous question I got no answers or any help,
> yet it is for me great problem.
> I can't get DB properties from any DB on any
> instance of three installed. EM shut itself down instead,
> without any warning or error message.
> I need to change some data types and collation settings.
> Any help (desperately needed) would be appreciated!
> Peter
> --
> Message posted via http://www.sqlmonster.com
|||Hi,
I am sorry for late answer, but i've been busy lately.
Yes, I tried reregister sqldmo.dll and it helped.
But I am curious what couses that mysterious
disappearance of properties.
Thank you very much for your help!
Sincerely,
Peter
Message posted via http://www.sqlmonster.com
|||I'm not sure. I've had this myself on my home PC and can't remember doing
anything that should have affected it. Things like service packs/hotfixes
etc could do it. Generally, (re)registering sqldmo.dll seems to fix it.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Peter K. via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:689d519bd4d849318cf6cc5442345bbb@.SQLMonster.c om...
> Hi,
> I am sorry for late answer, but i've been busy lately.
> Yes, I tried reregister sqldmo.dll and it helped.
> But I am curious what couses that mysterious
> disappearance of properties.
> Thank you very much for your help!
> Sincerely,
> Peter
> --
> Message posted via http://www.sqlmonster.com