dbo.sp_EstTableSize script

  • Hi - I'm trying to install this script from the CD that came with Inside SQLServer2000 (Kalen Delaney), but get errors when I run it:

    Server: Msg 128, Level 15, State 1, Procedure sp_EstTableSize, Line 131

    The name ' ' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.

    Server: Msg 128, Level 15, State 1, Procedure sp_EstTableSize, Line 132

    The name 'Usage:' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.

    etc.

     

    Anybody else out there had this problem?

    Thanks

  • Can you post the script (or at least the relevant bits of it)?  Are you running on SQL2K or SQL2K5?

  • Does your table name contain spaces?

    Far away is close at hand in the images of elsewhere.
    Anon.

  • Is the script using double quotes for strings and not setting QUOTED_IDENTIFIER properly?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply