MSDE 2000 behind WSUS server

Hello,
I'm a network / server guy at heart who has been given a quasi-DBA hat
to wear lately, so bear with me.
I have a WSUS (localized Windows updates) server that uses MSDE 2000
as its back end. Since last weekend I started to get an error that
points to a database problem. For the curious, read this:
http://support.microsoft.com/kb/910847
I am disgusted that I cannot go somewhere to download the hotfix, but
rather, I have to call and ask for it. And hope to not get charged for
the call. So, what I'm looking for are utilities that will allow me to
peek inside the database and try to do some cleanup. I'm not finding
much.
I found some command line utilities buried in the directory structure,
like the query tool osql.exe, and dtsrun.exe for DTS packages. But
anything this low level quickly puts me out of my comfort zone. It
seems as though Microsoft has gone to great lengths to keep the
innards of WSUS a secret. Anybody have any ideas how to expose them?
Thanks,
Justin
what.. you want to know more about the schema?
I don't think that it's reccomended that anyone go into the schema and
change anything.. if that's what you're referring to
I know in a heartbeat a real SQL person can dig through a 100 tables in an
hour and have a clue whats going on
<jschick@.aafp.org> wrote in message
news:1177614911.411800.103200@.r3g2000prh.googlegro ups.com...
> Hello,
> I'm a network / server guy at heart who has been given a quasi-DBA hat
> to wear lately, so bear with me.
> I have a WSUS (localized Windows updates) server that uses MSDE 2000
> as its back end. Since last weekend I started to get an error that
> points to a database problem. For the curious, read this:
> http://support.microsoft.com/kb/910847
> I am disgusted that I cannot go somewhere to download the hotfix, but
> rather, I have to call and ask for it. And hope to not get charged for
> the call. So, what I'm looking for are utilities that will allow me to
> peek inside the database and try to do some cleanup. I'm not finding
> much.
> I found some command line utilities buried in the directory structure,
> like the query tool osql.exe, and dtsrun.exe for DTS packages. But
> anything this low level quickly puts me out of my comfort zone. It
> seems as though Microsoft has gone to great lengths to keep the
> innards of WSUS a secret. Anybody have any ideas how to expose them?
> Thanks,
> Justin
>