If you try to create a folder or add a file, and get the error “A database error has occurred (FailDBInsert)”, or see this error in the Vault client message pane:
"Server unavailable for transaction end.
Transaction failed."
there may be a problem with the configuration of the SQL server hosting the sgvault database. Check the contents of the Vault log file in %windir%\temp\sgvault. You may see lines that say “XML stored procedures are not supported in fibers mode”.
To fix this problem, launch SQL Enterprise manager and right click on the local database group, and choose properties. Go to the processor tab, and uncheck the box “Use Windows NT fibers”. You will be required to restart SQL server. If you are using MSDE, run isqlw and
sp_configure 'lightweight pooling', 0
RECONFIGURE
GO
You can also run this from Query Analyzer
More info at this link:
http://support.sourcegear.com/viewtopic.php?t=1373
XML stored procedures are not supported in fibers mode
Moderator: SourceGear
XML stored procedures are not supported in fibers mode
Linda Bauer
SourceGear
Technical Support Manager
SourceGear
Technical Support Manager