Results 1 to 3 of 3

Thread: Msg 2715 after upgrade to SQL2005

  1. #1
    Join Date
    Mar 2008
    Posts
    5

    Msg 2715 after upgrade to SQL2005

    After upgrading to MSSQL 2005 we have stored procedures which get this error
    Msg 2715, Level 16, State 7, Procedure prc_sel_accruals, Line 37
    Column, parameter, or variable #15: Cannot find data type umoney.

    The user data type is defined in the database. I tried recompiling the SP, which suucceeds but then fails on execution.

    The SP works under SQL2000. Is there anything we need to do after the conversion?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Can you post the definition of alias data type.

  3. #3
    Join Date
    Mar 2008
    Posts
    5
    actually I just found the issue. The SP was creating the table in tempdb, so i needed to define the user data type there too along with the user DB. I also added it to model so it will stay in tempdb after a reboot. thanks...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •