KBA-01203: Restoring a Microsoft Dynamics SL database over another
Purpose & Scope: How to create a Test Microsoft Dynamics SL company from my Live Microsoft Dynamics SL company. Procedure:…
Read more
Tag Archive: SQL
KBA-01609: Project Cost Analysis Summary Data
Question: What’s the fastest way to grab project cost analysis data for reporting? Answer: Project Cost Analysis data includes amounts…
Read more
KBA-01602: Understanding how Project Teams are Stored in the Database
Question: How and where is the project team stored? Can I update the project team from external sources? Can I update…
Read more
KBA-01597: Extending the Contact Save Transaction
Question: How can I update other SQL data when a Spitfire contact is saved? Can I inject complicated validations and business…
Read more
KBA-01595: Naming Automatically Attached Files from Templates
Purpose & Scope: How to name automatically attached files from templates. Procedure: The system default is controlled by the template name…
Read more
KBA-01262: How to replicate a folder structure from a network drive to the Spitfire catalog
Purpose & Scope: Use Spitfire‘s sfLoadFile utility to create folders in the Spitfire Catalog based on an existing set of…
Read more
KBA-01183: Extensions to Document Save Transaction; SaveCustomDocExtn Rules
Question: How can I update other SQL data when a Spitfire document is saved? Can I inject complicated validations and…
Read more
KBA-01511: Using Subordinate Documents
Question: Can I have a custom Doc type include a TO tab like the Bid Package, where other related documents…
Read more
KBA-01582: Password Expiration and Requiring a New Password
Question: Can I set a minimum for password length? Can I make passwords expire after a certain number of days?…
Read more
KBA-01473: Best Practices: SQL Maintenance
Question: How should I set up my SQL Maintenance Plan? Answer: The overall strategy is to use SQL‘s maintenance tool. …
Read more