Summary: With SQL Server 2005, population of the Full-Text Index can occur on an automatic basis. Spitfire Catalog searches of the Full Text Index should then always be up to date. Requirement: In ICTool,
Summary: With SQL Server 2005, population of the Full-Text Index can occur on an automatic basis. Spitfire Catalog searches of the Full Text Index should then always be up to date. Requirement: In ICTool,
Question: How can I tell if Full-text Indexing is installed in Microsoft SQL Server? Answer: In Query Analyzer, run the following command: SELECT fulltextserviceproperty('IsFulltextInstalled') 1 = installed 0 = not
Question: In the Project Lookup, how can I change the Address2 field label to Floor? Answer: Add the following script to Site_Wrapup.sql UPDATE dbo.xsfLookupField SET label = ‘Floor‘, WParamLabel= ‘Floor‘
Purpose & Scope: The test database has been configured with roles, users, default routes, etc. and now you‘d like to use the test database as the base for your live Spitfire database. The
Question: If I make a change directly in the Spitfire database using SQL Query Analyzer or SQL Enterprise Manager, how do I ensure that the next Spitfire update with a
Question: I have users who need to run their report and do not want to have to specify the report parameters every time. How can I streamline their reports? Answer: The
Question: In my custom report, how do I enter an expression that deals with a field that can be NULL? Answer: Many fields in sfPMS are stored as NULL values