KBA-01489: Understanding how Documents are Stored in the DatabaseKBA-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 are just an average user, probably not. This is way

KBA-01001: How much SQL storage is required to store files in sfPMS?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 is required to store a file within sfPMS as within

KBA-01559: Symptoms of Server Time Sync FailureKBA-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 to save? Why are users getting some other user has

KBA-01417: Manual Security Setup for Spitfire to access SQL Server Reporting Services CatalogKBA-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 Spitfire database. The SSRS ReportServer database resides on a different

KBA-01445: Overview of the ReportConfig RulesKBA-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 ReportConfig rule group is found in the Rules Maintenance tool

KBA-01471: Moving Cataloged Files to ArchiveKBA-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: Both Spitfire and SQL have tools to deal with terabytes

KBA-01540: Custom Lookups and AutoCompleteKBA-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 several reasons why a custom lookup might not exhibit expected

KBA-01515: SQL Server VirtualizationKBA-01515: SQL Server Virtualization

Question: Is it OK to use a virtual SQL Server? Are there things I should consider when planning virtualization of the SQL Server? Answer: Plenty of folks now deploy SQL

KBA-01450: Troubleshooting SQL DeadlocksKBA-01450: Troubleshooting SQL Deadlocks

Question: What does Transaction (Process ID nn) was deadlocked on lock resources with another process and has been chosen as the deadlock victim… mean? Answer: Most simply, it means that

KBA-01264: How To Import Projects on a Regular ScheduleKBA-01264: How To Import Projects on a Regular Schedule

Purpose & Scope: Projects are created in Microsoft Dynamics SL on a regular basis and need to be imported into Spitfire. Procedure: Spitfire has a stored procedure that will create