locked
TSD160: 'POWERSUM' is not a recognized built-in function name.

    Question

  • Hello.

    I use VS2005 Team Suit and SQL Express.
    When I attempt build my database project I get error message: Error TSD160: 'POWERSUM' is not a recognized built-in function name. Same error message I get when I try compare database project with target database. How can I solve this problem ?

    Thanks in advance .
    Wednesday, October 20, 2010 9:46 AM

Answers

  • After many attempts without success to solve this problem I decided to switch to VS 2010. Now everything works fine.

    Thanks again for the help.
    Thursday, October 28, 2010 6:45 AM

All replies

  • This is a known issue since PowerSum is a undocumented and deprecated function which is not supported to be used, hence not supported by the parser. PowerSum has been removed from SQL Server 2008.

     


    GertD @ www.DBProj.com
    Wednesday, October 20, 2010 5:11 PM
  • I know about this trouble. Is there a workaround to this problem ?
    Why VS 2005 uses this
    deprecated function or this problem exists only on my machine (I use SQL Server Express 2005) ?
    There may be a update for VS 2005 ?
    Thursday, October 21, 2010 6:57 AM
  • VS did not deprecate the PwoerSum function, SQL Server did. VS database prjects never supported PowerSum explicitly. There is no workaround I amd very certain it will never get fixed, as PowerSum was never a supported function to begin with. This is the risk of using undocumented functionality.

      


    GertD @ www.DBProj.com
    Thursday, October 21, 2010 4:10 PM
  • Sorry, I'm a little confused.

    I am not using PowerSum function in my database project. Keyword search does not return any results. This means that, when I do Build, VS generates SQL query with PowerSum function and SQL Server can't compile this query and return exception.

    Building deployment script for TestDatabase : EnableFullTextSearch, BlockIncrementalDeploymentIfDataLoss
    Error TSD160: 'POWERSUM' is not a recognized built-in function name.
    Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
    Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
    Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
    'POWERSUM' is not a recognized built-in function name.
    Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
    Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
    Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
    Done building project "Database1.dbproj" -- FAILED.

    Build FAILED.
    ========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========

    Please, correct me if I misunderstand.

    Friday, October 22, 2010 8:37 AM
  • I am certain Visual Studio Database Project themselves never uses the PowerSum function, it must be somewhere in your code / files. If you want you can zip up the project and send it to me and I will look at it.

     


    GertD @ www.DBProj.com
    Friday, October 22, 2010 10:12 PM
  • After many attempts without success to solve this problem I decided to switch to VS 2010. Now everything works fine.

    Thanks again for the help.
    Thursday, October 28, 2010 6:45 AM
  • Were you using SQL Express as the design database instance?
    GertD @ www.DBProj.com
    Monday, November 01, 2010 5:19 PM