Home Forums SQL Server 7,2000 T-SQL Get file size RE: Get file size

  • December 21, 2006 at 6:59 am

    #679400

    Ok, thanks... isn't that the way?  Company buys something and that won't let you use it which forces you to revert to undocumented features in SQL Server...

    This will work in SQL Server 2000 and SQL Server 2005 and you don't need SA privs to use it... Master.dbo.xp_GetFileDetails comes with SQL Server...

    EXEC Master.dbo.xp_GetFileDetails 'pathandfilenamehere'

    ...or...

    EXEC Master.dbo.xp_GetFileDetails 'uncpathandfilenamehere'

     

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)