Post reply

Couldnot find stored procedure sp_send_cdosysmail in sql server 2000

  • August 20, 2008 at 2:18 pm

    #70647

    Hi

    On of my production server the whenver i am trying to use Stored Procedure sp_send_cdosysmail , i am getting error messgage

    " Couldnot find stored procedure sp_send_cdosysmail "

    Same SP i am using on my other server and it is running fine . Then i checked sql versions on both :

    a) Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2, v.4035) ---------- HERE SP IS NOT WORKING

    b) Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

    --- HERE IT IS WORKING

    So can any advice , do i need to install service pack for this???

  • August 20, 2008 at 2:40 pm

    #860897

    this may help you:

    http://support.microsoft.com/kb/312839

  • August 21, 2008 at 3:48 am

    #861099

    nikhil.verma (8/20/2008)

    Thanks for ur Help!!!!!!!!

    But i have checked the link and couldnt find suitable info abt my prob .

    The entire creation script for that stored proc is in the kb article.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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