August 28, 2002 at 7:38 am
I have a SQL Server installation that is missing the stored procedures used for mail (xp_startmail, xp_stopmail, etc.). Is there a way that I can install these without having to reinstall SQL? I tried to generate script for them from other servers but SQL won't let you do that with these particular stored procedures.
August 28, 2002 at 7:47 am
It sounds like someone took the time to drop these extended stored procedures, probably for security reasons. To re-add them, use the system stored procedure sp_addextendedproc. You'll need to know the DLL where the extended stored procedure can be found, and this information is stored in syscomments (join against sysobjects based on id) in the [text] field. You can also use sp_helpextendedproc as well.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
August 28, 2002 at 8:23 am
I can't find any stored procedures related to mail in the Text field of Syscomments. The sp_helpextendedproc doesn't contain any info on mail related stored procedures either.
Also, I look at the sysobjects table but couldn't find any mail related stored procedures there either.
August 28, 2002 at 8:30 am
Nevermind, I got it. I went to a server that had the mail xp's on it and did exactly what you said to do, and it worked.
Thank you for your help!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply