Home Forums SQL Server 2008 T-SQL (SS2K8) How do I get database space used RE: How do I get database space used

  • November 20, 2012 at 1:42 am

    #1560637

    sql-lover (11/19/2012)

    Use COLLATION clause in one of the joins .. 😉

    If you have a database with a different collation like me, you'll get that error.

    Except the collation, your code does not work properly i.e. it does not list sizes for all databases but only for the currently used. The one-line code above is the solution for you.

    Regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com