Subject: Set Compatibility Level on All DBs /* Update All DBs Compatibility Level */ /* Reference 2017 = 140 Azure SQL Database = 130 2016 = 130 2014 = 120 2012 = 110 2008R2 = 100 2008 = 100 2005 = 90 2000 = 80 */ DECLARE @SQL VARCHAR(max) = ”, @CL int =
Subject: Server Rename SQL Instance Rename –For Default Instance sp_dropserver <old_name>; GO sp_addserver <new_name>, local; GO –Restart the instance of SQL Server. –/*For a renamed computer that hosts a named instance of SQL Server, run the following procedures:*/ sp_dropserver <old_name\instancename>; GO sp_addserver <new_name\instancename>, local; GO –Restart the instance of SQL Server
Subject: MAX PDF Documents have References in the Registry and in the ExaxctRMNET.ini Registry: [HKEY_CURRENT_USER\Software\ExactRM] ExactRMNet.ini is the windows folder
Subject: Move ODBC from one workstation to another Transfer DSN files from Computer A to Computer B: 1. On Computer A, open the Registry Editor by typing "regedit" in the Windows search box under the Start menu and selecting regedit.exe 2. Navigate to the following registry key : · For User DSN data sources: HKEY_CURRENT_USER…
Subject: SSRS and Chrome Links and Fixes Chrome Chrome Extension for SSRS >> Solves Rendering Problems https://chrome.google.com/webstore/category/extensions?hl=en-US Solves CSS Issues https://chrome.google.com/webstore/detail/sql-reporting-viewer-fix/ealmmhekjbgnbfllfpbpplccpeoplidp?hl=en
Subject: Knowledge Sync Apps will not run Likely it is these 2 files causing troubles. STOP THE KNOWLEDGESYNC WINDOWS SERVICE Move MSCOMCTL.OCX and COMDLG32.OCXC:\WINDOWS\syswow64 regsvr32 C:\WINDOWS\syswow64\ MSCOMCTL.OCX 6/6/2012 regsvr32 C:\WINDOWS\syswow64\ COMDLG32.OCX 5/7/1999 START THE KNOWLEDGSYNC WINDOWS SERVICE.
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…