You guys will notice a previous response from me - I guess it can be ignored. Sorry I didn't read on and am just catching up on the afternoon. I see you guys have already twigged on to the key part of my reply - that the extended stored procedures can bring down the server - and with a lot less words than me.
In defense of MS - since you guys don't know me, let me just clarify that I rarely come to the defense of MS - they are providing a mechanism that may address some peoples needs. The mechanism allows you to extend the server in just about any manner conceivable since you can write your code in C++ and access the entire system. Unfortunately that freedom comes with a great responsibilty because your code becomes part of the server. Thus it should only be used when absolutely necessary and with great care. Just like you should be careful playing with very sharp knives. Phill -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: July 12, 2002 2:24 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] An SQL Server Question I believe it, but that's terrible. The very thought that any one process can accidentally cause the server to terminate is horrible. There should be *nothing* that a database connection client can do to bring the backend down. Anything short of that is simply poor error checking/recovery on the part of the makers of the backend. Perhaps if you offered to pay M$ more money they would produce a more robust SQL server? Or maybe you can get a better version with the next upgrade AKA PATCH. Terry Fielder Network Engineer Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Kevin Brown > Sent: Friday, July 12, 2002 2:07 PM > To: [EMAIL PROTECTED] > Subject: RE: [CFTALKTor] An SQL Server Question > > > 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) - 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: "Phill Addorisio" <[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)
