Browse By Tags

  • Wiki Page: 492-17885 - User Access Logging database performance issues

    Summary: Errors being logged by the User Access Logging (UAL) feature in Windows Server 2012 may result in poor database server performance. Symptoms: Users may report poor database performance when interacting with Sage CRM. This may take the form of timeouts, or actions taking longer than expected...
  • Wiki Page: 710-18095 - SQL Views script

    Summary: This will list all of the views on the database with a column highlighting if they are working correctly or not. Views that are populated with ‘Bad’ will need to be dropped or refreshed. Please also be aware that some views are dependent on other views. Once you have fixed the issue...
  • Wiki Page: 710-18102 - SQL script that can be used to search a database for text.

    Summary: SQL script that can be used to search a database for text. Resolution: DECLARE @search_string VARCHAR(100), @table_name SYSNAME, @table_id INT, @column_name SYSNAME, @sql_string VARCHAR(2000) SET @search_string = 'Test' DECLARE tables_cur CURSOR FOR SELECT name, object_id FROM sys.objects...