KBA-01489: Understanding how Documents are Stored in the Database
Question: How and where is the data on my document stored? Can you help me understand the schema? Answer: If you…
Read more
Tag Archive: SQL
KBA-01001: How much SQL storage is required to store files in sfPMS?
Question How much storage is required to store files in SQL for Spitfire? Answer Roughly the same amount of storage…
Read more
KBA-01559: Symptoms of Server Time Sync Failure
Question: Why are users getting You do not have update access to the document at this time when they try…
Read more
KBA-01417: Manual Security Setup for Spitfire to access SQL Server Reporting Services Catalog
Summary: There are two basic deployment scenarios: The SSRS ReportServer database resides on the same instance of SQL as the…
Read more
KBA-01445: Overview of the ReportConfig Rules
Overview: The ReportConfig rules allow customization of SQL Server Reporting Services (SSRS) RDL paths and provides default report parameters. The…
Read more
KBA-01471: Moving Cataloged Files to Archive
Question: My Spitfire Catalog has grown quite large. How do I avoid backing it all up all the time? Answer:…
Read more
KBA-01540: Custom Lookups and AutoComplete
Question: Why doesn‘t AutoComplete work with one custom lookup? How does AutoComplete know what fields to search? Answer: There are…
Read more
KBA-01533: Full-text searches not working from the Catalog on Office 2007/2010 file types
Purpose & Scope: Contents of Microsoft Office 2007/2010 files types that have been uploaded to Spitfire are not found in…
Read more
KBA-01515: SQL Server Virtualization
Question: Is it OK to use a virtual SQL Server? Are there things I should consider when planning virtualization of…
Read more
KBA-01450: Troubleshooting SQL Deadlocks
Question: What does Transaction (Process ID nn) was deadlocked on lock resources with another process and has been chosen as…
Read more