Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jackstow
Posting Yak Master
160 Posts |
 Posted - 2001-12-17 : 09:00:09
|
OK - I have a table which fires off an email on insert. The trigger that fires the email uses a couple of extended stored procedures that are in the master database. This all works fine on the development server. However, now I have uploaded the db to the (new) hosting company's server (same setup Windows 2000 and SQL 2000), I get this error on insert - "OLE Automation objects are not supported in fiber mode" - which I do not like the sound of at all! This is going to be something that is out of my control and will be up to the db administator of the hosting company.. Am I right?Jack |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2001-12-17 : 09:07:32
|
It seems that there is a problem with fibers mode (or lightweight pooling). Have you seen this article:[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q308604[/url]It says they can't recommend using SQLmail or some extended procs when in fibers mode...  |
 |
|
|
jackstow
Posting Yak Master
160 Posts |
Posted - 2001-12-17 : 10:37:06
|
| OK - but I don't see why SQL is using lightweight pooling anyway - the server doesn't seem to meet any of the criterion for it - I've used sp_configure to set lightweight pooling to 0 - although I can change the config_value I can't get the run_value to change even using RECONFIGURE WITH OVERRIDE - any ideas?? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-17 : 11:14:29
|
| Have you rebooted the SQL Server? A lot of settings don't change with RECONFIGURE until you reboot/restart, even if it says they take effect immediately. You'll probably have to have the host do this for you.If your host is sharing the SQL Server, they might have a reason for keeping it in fiber mode...might run faster, fewer resources, etc. If they won't change the setting and you can't make it work, you're SOL. |
|
|
|
|
|
|
Fiber mode