Subject: Merging Word Documents Microsoft Word 2013: Combine and Merge Multiple Documents While working on documents using Microsoft Office Word, sometimes users may need to combine and merge many multiple documents into one single document. For example, when an author is writing a novel book by saving each chapter as individual documents this makes a…
Subject: Refreshing the Management Reporter Data Mart from Windows PowerShell Using "Reset-DatamartIntegration " REBUILD Management Reporter Datamart from Powershell: 1. Backup The ManagementReporter and Data Mart (ManagementReporterDM – default name – might be different) databases. 2. Log onto the server where the MR Server components are installed and open Powershell as Administrator. 3. Navigate to…
— List of Company IDs select CMPANYID, INTERID, CMPNYNAM from DYNAMICS..SY01500 — List of Product Versions for Company specified by Database select U.*, C.INTERID, C.CMPNYNAM from DYNAMICS..DU000020 U join Dynamics..SY01500 C on C.CMPANYID = U.companyID where C.INTERID = ‘TWO’ — Enter desired Company DB name order by U.PRODID — List of Product Versions for System…
Discussion: After a Microsoft Office security update it is possible that the Synergy Office Integration (SOI) buttons will no longer respond. In most cases the ‘Save’ button will work, but other buttons such as ‘Workspace’ or ‘Workflow’ do not respond to any click. This caused by the following security updates: Security Update for Microsoft Outlook…
After changing a computer name, how do you reset the computer name in SQL server so that its name matches the computer name When you change the name of the computer that is running SQL Server, the new name is recognized during SQL Server startup. You do not have to run Setup again to reset…
Updating Your MAX Test Environment NOTE: It is highly recommended that at least one workstation dedicated to use with your MAX Test Environment. STEP 1 – Update your RMTestServer to the same release as your RMServer. 1. Select all files folders in \\Exact\RMServer\Net and copy them to \\Exact\RMTestServer\Net. STEP 2 – Update your RMTestServer to…
This query allows you to get configuration data from the Dynamics DB directly.
CREATE PROCEDURE SP_TakeOfflineAllDatabase AS BEGIN DECLARE @db sysname, @q varchar(max); DECLARE cur_db CURSOR FOR SELECT name FROM sys.databases WHERE owner_sid <> 0x01; OPEN cur_db; WHILE 1=1 BEGIN FETCH NEXT FROM cur_db INTO @db; IF @@FETCH_STATUS <> 0 BREAK; SET @q = N’ALTER DATABASE [‘ + @db + N’] SET OFFLINE WITH NO_WAIT’; EXEC(@q); END; CLOSE…