Symbol What it is How it is read How it is used Sample expression + Addition sign … plus … Sum of a few values 3 + 5 = 8 Logical OR symbol … or … Logical disjunction ¬(A + B) = ¬A * ¬B * Multiplication sign … times … Product of two values…
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: 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…