SQL Server Performance

mmc freezing up

Discussion in 'Analysis Services/Data Warehousing' started by skeezwiz, May 3, 2006.

  1. skeezwiz New Member

    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
  2. satya Moderator

    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.

Share This Page