September 29, 2004 at 3:55 am
I am trying to use a trigger to send an e-mail through SMTP, However when i try and test the Stored prodcedure which sends the e-mail, i get an error that says OLE automation objects are not supported in fiber mode. Is there any other way i can achieve my aim? SQL mail is not set up and i have no ooutlook client installed on the server.
Any advice much appreciated
thank, ade
September 30, 2004 at 6:09 am
Lots of things are not supported or stop working when running in Fiber mode. A KB search for "Fiber mode" shows some of the issues.
My suggestion is to turn off Fiber mode unless you can prove you really need it.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
October 1, 2004 at 8:10 pm
If you find that you are using fibre mode for a shortage of threads you can always increase the amount of workerthreads. If you are using it to cut down on context swiching you may be stuck. Like EdVassie said there are several things that don't work in fibre mode.
Wes
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply