Forums Discuss HelpMaster
HelpMaster SQL Server database
Search this forum:
Search
You are not authorized to create a new topic
Page 1 of 3123 > >>
Topics
 Replies
 Views
 Last Post
0 Replies and 9373 Views Database changes for v12 - UTC date conversion - VERY IMPORTANT!    9373  0 Started by  Rod Weir Background HelpMaster v12 and above supports multiple timezones when entering, updating or viewing any date/time data.  This is very useful if you use HelpMaster across different timezones. In order to support this functionality, HelpMaster needs to store all date data in the database as UTC (Universal coordinated time).  When the date data is displayed to the end user, it is converted and displayed in local time.  If the timezone for the date is different to the local time, Hel...
0 9373
4/25/2012 9:08 PM
3 Replies and 20749 Views How to improve SQL Server performance and thus HelpMaster's too.  20749  3 Started by  Dennis Odri I recently helped one of our many valued clients with an issue where his HelpMaster services were just stopping periodically due to SQL Server timeouts and Exchange mailbox access timeouts. I discovered that they had only allocated 2GB RAM and a single CPU to their HelpMaster server which is a Virtual Machine which also hosts their HelpMaster database under SQL Server 2012 Express. It seems that SQL Server 2012 requires a minimum of 4GB of RAM on the host. I also recommended that he enables a...
3 20749
by  Josh BJump to last post
11/23/2016 2:53 PM
0 Replies and 6895 Views End of life notice for SQL Server 2005  6895  0 Started by  Rod Weir Support for SQL Server 2005 is coming to an end in 2016. https://support.microsoft.com/en-us/lifecyclep1=2855&wa=wsignin1.0  If you're still using SQL Server 2005 for HelpMaster (or any other system), please consider upgrading to a more recent version of SQL Server soon. If you need any help with this please contact PRD Software and we can help you.
0 6895
9/18/2015 11:08 AM
1 Replies and 9373 Views Database and Report Wizard Error  9373  1 Started by  Robert Bean HelpMaster 13.6.4 Database Patch Log File ============================================ Please report any errors to PRD Software at supportprdsoftware.com.au ---------------------------------------- Connection string: Integrated Security=SSPI;Initial Catalog=HelpMaster;Data Source=DMBAPP;Connect Timeout=300; 6/26/2013 6:37:16 PM   Patch started. 6/26/2013 6:37:16 PM   Applying patch version &39;1&39;... 6/26/2013 6:37:16 PM   Updating Database Compatibil...
1 9373
by  Rod WeirJump to last post
7/4/2013 8:24 PM
0 Replies and 8992 Views SQL script to capitalize the First and Last name of each client  8992  0 Started by  Rod Weir We recently had a request to ensure that the frist letter of a client&39;s First name and Last name was always captalized.  HelpMaster currently does not have this functionality built-in, but running the following SQL script will update your database to make the first letter of each name a capital letter. This script can be run at any time - even scheduled to run at regular intervals if required. Update tblPerson Set Firstname = Upper(Left(FirstName,1)) Substring(FirstName,2,254),...
0 8992
4/22/2013 5:26 PM
You are not authorized to create a new topic
Forums Discuss HelpMaster HelpMaster SQL Server database
Page 1 of 3123 > >>


RSS Feed Available
New version - HelpMaster v24 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

 New version - HelpMaster v23 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

 March 2023 v22.7 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

 July 2022 release now available - New version released! by Rod Weir in Announcements with 0 replies A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

 June 2022 v22.2 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...
RE: Use PowerBI for HelpMaster dashboards by Rod Weir in Reports and reporting Hi SR, Thanks for the post. Yes, the PowerBI reports for HelpMaster have been well received. Download the latest version, from here. https://www...

 RE: Use PowerBI for HelpMaster dashboards by Scenic_Rim_IT in Reports and reporting Hi Rod - just wondering how PowerBI reports are going? Any chance you have a beta/pre-release version we can help test for you?...

 New version - HelpMaster v24 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

 New version - HelpMaster v23 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

 March 2023 v22.7 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

 July 2022 release now available - New version released! by Rod Weir in Announcements A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

 June 2022 v22.2 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

 February 2022 release now available - New version released! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

 November 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

 May 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v21, see the new documentation site https://docs.helpma...