Post reply

urgent help needed

  • October 7, 2008 at 10:49 am

    #198952

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

    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 11:33 am

    #881854

    make sure you're in the appropriate database context.

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

  • October 7, 2008 at 12:13 pm

    #881876

    Look for the object under a different owner.

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

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