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)
