SQL Server Performance Forum – Threads Archive

mmc freezing up

Hi, not sure what the problem is but when I try and log into analysis services (SP3a) via the gui and click on a database it just hangs and there is no way of deleting that particular db so I can replace it. There is minimal activity on the SQL box but it still hangs??
I even tried running this script with no luck. Dim dsoServer
Dim OLAPdb Set dsoServer = CreateObject("DSO.Server")
dsoServer.Connect "server name" OLAPdb = "db name" if dsoServer.MDStores.Find(OLAPdb) then
Wscript.Echo ("deleting " & OLAPdb & " db…")
dsoServer.MDStores.Remove(OLAPdb)
else
Wscript.Echo (OLAPdb & " db not found!")
end if set dsoServer = Nothing
set dsoDatabase = Nothing

Try from another client’s machine, may be problem with client tools on this machine. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>