Post reply

urgent help needed

  • October 7, 2008 at 12:08 pm

    #77105

    why cant I add the procedure when its not in the database but sqlserver still saying its already in database ?

    I restarted the sql server so I am sure nothing is in memory, and also sp_help xp_smtp_sendmail returns no rows.

    thanks

    exec sp_dropextendedproc 'xp_smtp_sendmail'

    Cannot drop the procedure 'xp_smtp_sendmail', because it does not exist in the system catalog.

    exec sp_addextendedproc xp_smtp_sendmail, 'c:\xpsmtp80.dll'

    There is already an object named 'xp_smtp_sendmail' in the database.

    There is already an object named 'xp_smtp_sendmail' in the database.

    no rows returned

  • October 7, 2008 at 12:16 pm

    #881877

    Please do not cross post.

    This has already been posted here...

    http://www.sqlservercentral.com/Forums/Topic581994-24-1.aspx

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • October 7, 2008 at 12:24 pm

    #881882

    sorry I by mistake put it in the backup group and i was told to move it to the right area so I put it here.

  • October 7, 2008 at 12:59 pm

    #881910

    ok its giving me error on any procedure I add . what could be the reason ? is the syntax wrong ?

    exec sp_addextendedproc 'ABCAD', 'FADSFADFASF'

    Server: Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 26

    There is already an object named 'ABCAD' in the database.

  • October 7, 2008 at 1:07 pm

    #881916

    Any chance you are not in the fixed sysadmin server role?

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • October 7, 2008 at 1:28 pm

    #881934

    i am using sa account to do this , doesnt sa account has all the rights n roles?

    how and which roles can i explictly grant to sa ?

  • October 7, 2008 at 1:38 pm

    #881942

    yes the SA user is a member of the fixed sysadmin role by default, however I would seriously think about using a different way to connect to the server as using sa isn't what you might consider a best practice. The sa user also may not have permissions to the directory where you are storing your dll. You may want to try connecting with a windows accoutn which has SysAdmin rights and running the command again.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • October 7, 2008 at 1:42 pm

    #881944

    sahmad43 (10/7/2008)

    ok its giving me error on any procedure I add . what could be the reason ? is the syntax wrong ?

    exec sp_addextendedproc 'ABCAD', 'FADSFADFASF'

    Server: Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 26

    There is already an object named 'ABCAD' in the database.

    Please run the following in the DB that you're trying to run that in.

    SELECT * from sysobjects where name = 'ABCAD'

    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

  • October 7, 2008 at 2:10 pm

    #881960

    ok I changed the authentication mode to windows and logged in using windows authentication but still same error.

    and Jill i get no rows if i give your command for selecting from sysobjects for this object name . Iam sure sqlserver is giving misleading errror

  • October 7, 2008 at 2:30 pm

    #881976

    What database are you trying to add the extended proc to?

    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

  • October 7, 2008 at 3:27 pm

    #882005

    found the problem. . its a microsoft bug for sqlserver 2000 . ..

    and there is a work around

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

Viewing 11 posts - 1 through 10 (of 10 total)

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