The OA procedures are set of extended procedure which give access to COM objects (ActiveX DLL among others).
You must be careful whom you give access to these sp because if an in-process dll call is made and it dies a "horrific death" (fatal error) it will bring down the calling process also and in this case SQL Server. It also has the potential of corrupting the memory space because in-process dll share the same memory space as the calling process. Please some one correct me if I'm wrong or clarify further. Thanks, ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Kevin Brown Operations ~~=========================~~ Datex Billing Services, Inc. 775 Pacific Road, Unit #31 Oakville, ON L6L 6M4 Phone: (905) 465-3255 x227 Fax: (905) 465-3385 Email: [EMAIL PROTECTED] ~~=========================~~ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, July 12, 2002 11:26 AM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] An SQL Server Question Could be a "feature" in M$ SQL server where MS does something special with stored procedures that begin with OA. MS is known for undocumented querks like that, rather then implementing a proper solution for special cases (hackers love finding them). Eg, did you know that one cannot create a directory called "con" in windows??? Similar "feature" perhaps... Terry Fielder Network Engineer Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Mark D'Souza > Sent: Friday, July 12, 2002 11:03 AM > To: [EMAIL PROTECTED] > Subject: [CFTALKTor] An SQL Server Question > > > I know this isn't the forum for this but I need an answer quick so I > post it in few places. Any help would be mundo appreciated. > > Are there any issues that any of you are aware of with respect to > granting permissions on extended stored procedures? > Specifically, those > stored procedures beginning with 'OA'? One of our sites is > on a shared > server and the entire server crashed sourcing a fatal error > connected to > an extended stored procedure. All databases were moved to a > new server > but the company is no longer willing to grant us access to > the extended > stored procedures we require (the ones beginning with 'OA'). > > Thoughts? > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rick Mason Sent: July 12, 2002 10:40 AM To: [EMAIL PROTECTED] Subject: [CFTALKTor] CF Hosts I know there has been plenty of discussion here about recommended hosts and that one of the most recommended was Crystaltech. We've now launched 2 sites on Crystaltech and the sites run very slow in comparison to similar sites we've launched in other shared hosting environments. I'm just wondering if anyone else has had similar experiences with them. Also, I'm wondering if anyone can suggest a Canadian host with similar levels of service, control over the CF settings and pricing. Rick - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Rick Mason" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Mark D'Souza" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Kevin Brown" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
