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…
In order to downgrade SQL for a move of GP data files to an unsupported version you must perform this task to rebuild the GP database in an earlier version. https://support.microsoft.com/en-gb/help/875179/how-to-use-the-bulk-copy-process-bcp-to-export-microsoft-dynamics-gp-d Vince
DYNAMICS GP & SQL Server and OS Versions Dynamics 10 (Off Support) Windows Server 2008 R2 , 2003 Microsoft SQL Server 2000 SP 4 Microsoft SQL Server 2005 SP 2 or SP 3 Microsoft SQL Server 2008 with or without SP 1 Microsoft SQL Server 2008 R2 NOTE: Service Pack 5 or later for Microsoft…