November 30, 2004 at 1:58 am
Hi - I was following this article: http://www.sqlservercentral.com/columnists/dharris/sendingsqlnotificationswithcdosys.asp
...but it refers to 2 SPs which don't appear in my MSDE, namely 'sp_OACreate' and ‘sp_OASetProperty'
I'm running Windows 2003 Web Edition, with MSDE 2000.
Could anyone please advise where I can get these SPs and if they will work with my setup?
Thanks for any help,
Mark
November 30, 2004 at 2:21 am
Both procedures are located in the master database. Did you already search there?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 30, 2004 at 2:28 am
Hi Frank - yes I did look in Master too - and they're not there. I thought it may have been because I was using MSDE 2000.
Thanks, Mark
November 30, 2004 at 2:34 am
Hm, sorry, I have no experience with MSDE. Would this be an alternative?
http://www.sqldev.net/xp/xpsmtp.htm
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 30, 2004 at 2:39 am
Hi Frank - yes it would - it seems to have good feedback in the forums too.
Thanks for your help,
Kind regards, Mark
November 30, 2004 at 2:42 am
You're welcome!
Glad I could help.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 30, 2004 at 11:54 am
For the record-
I just checked our MSDE instance, and sp_oacreate and its partners exist in the extended stored procedures grouping in Enterprise Manager.
Steve
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply