Home Forums SQL Server 2005 Administering Retrieving a graphical representation of used/total space in all databases on a server RE: Retrieving a graphical representation of used/total space in all databases on a server

  • Hi there,

    Thanks for sharing this simple yet useful scripts. One thing that you should change though is the was you execute the Use DB because you can have a DB with a character like "-" that will fail. I found this on my laptop with a sharepoint DB. Usually, when you create a new web application in sharepoint and you don't change the DB name, it uses custom name that contains that character, so changing this

    objConnection.Execute("use " & dbname)

    to this

    objConnection.Execute("use [" & dbname & "]")

    do the work.

    Thanks again for sharing these stuff,

    Alejandro

    Alejandro Pelc