Post reply

Enterprise Manager - call to function fails

  • August 31, 2005 at 8:54 am

    #102757

    We just installed SP4 on our Windows2003 box to SQL2000 server.  Now, when using EM to write a view that calls a function, the function call fails with a convert error.  The oddity is that prior views/sps with this function call work just fine (unless you delete it and try to re-insert it).  Writing the same query through Query Analyzer works as expected.

    Does anyone know about any SP4 problems with EM that might be causing this?  This is the only issue I've seen at this point that is a problem.

    Note: our SQL was reinstalled yesterday evening as well (which is when our network manager took us from SP3 to SP4).

  • August 31, 2005 at 9:03 am

    #586505

    Does EM on the server work?

    Not on your workstation?

    Patch your client tools.

    What about through Query Anayzer? The better way to develop code...

  • August 31, 2005 at 9:06 am

    #586506

    I am trying to use EM on the workstation.  I'll try it from the server.  I also haven't patched the client tools.  I will look for a patch now.

    Thanks for the hints.

  • August 31, 2005 at 9:07 am

    #586507

    No special patch, just apply SP4...

  • August 31, 2005 at 9:15 am

    #586514

    SP4 was installed last night after SQL was reinstalled.  We were previously at SP3A for our patch.  I am not sure if the problem with EM is coming from SP4 or from the reinstall of SQL.  I would think if it were SQL, however, the problem would be the same through EM and through query analyzer.

     

    Thanks again for your help.

  • August 31, 2005 at 9:18 am

    #586516

    Nope, it's how EM connects to SQL.

    In QA it would be a simple "CREATE VIEW..." but EM may not use this method or use soem sp_ or use DMO etc and now there is a discrepancy between what SP*a EM expects and what SP4 SQL Server is presenting...

    Have you tried on teh server? Patched client tools?

  • August 31, 2005 at 9:58 am

    #586549

    I tried it on the server and I patched my client tools.  Same result in each location.

  • August 31, 2005 at 10:00 am

    #586552

    Ah well, it could just be something in your DDL.

    Try QA.

    Or post the DDL.

Viewing 8 posts - 1 through 7 (of 7 total)

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