Start a conversation Sign in
Start a conversation
  1. Digital Retail Solutions
  2. Self Service KB

SQL Server

  • RMS db schema script

    select schema_name(tab.schema_id) as schema_name, tab.name as table_name, col.column_id, col.name as column_name, t.name as data_type, col.max_length, col.precision from sys.tables as tab inner join s...

  • 2008 R2 SQL Server Manager on Windows 10 (start/stop)

    Control Panel, Administrator Tools, Services, SQL Server, Start (Automatic enabled). Or search Windows folder in File Explorer for SQLSERVERMANAGER and the appropriate version will list such as SQLSER...

  • Corrupted log file recovery

    https://community.dynamics.com/rms/f/microsoft-dynamics-rms-forum/136014/700gb-log-file-now-system-will-not-work-help/291350#291350 Try rebuild, check, shrink first....

  • SQL versions and service packs

    https://sqlserverbuilds.blogspot.com/ IMPORTANT: DRS does not support RMS or DRS add-ins running on SQL versions higher than 2008 R2. Support for higher versions is available from alternate support pr...

  • SQL Server Configuration Manager (shortcut missing)

    SQL Server 2016 -- C:\Windows\SysWOW64\SQLServerManager13.msc SQL Server 2014 (12.x) -- C:\Windows\SysWOW64\SQLServerManager12.msc SQL Server 2012 (11.x) -- C:\Windows\SysWOW64\SQLServerManager11.msc ...

  • How to determine SQL version

    Simple query:  select @@version Or: SELECT SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition'), @@version Detailed methods:  https://www.mssqltips.com/sqlservertip/1140/how-to-tell-what-sql-se...

  • SQL 2005 Express support has ended (SQL 2008 R2 upgrade)

    Extended support for SQL Server 2005 ended on April 12, 2016. If you are running SQL Server 2005 after this date you will no longer receive security updates and technical support. This doesn't mean SQ...

  • POS 2009 server setup

    Ports to firewall -- 1976 for SQL Server (other SQL Server installations use port 1433) TDP: 139, 445 UDP: 137, 138 Registry hack -- Enable Local Account Token Filter Policy Regedit Expand the followi...

  • SQL 2008 installed before RMS

    The downside to this procedure is (local) won't work -- must use <servername>/instance -- and that means the DRS CR reports won't run on server. So preferred method is to install RMS with SQL 2005 fir...

  • How do I reindex my database or run a database check to ensure table integrity?

    If store database, run Store Operations Administrator. If HQ database, run Headquarters Administrator. Select File, Connect, enter your SQL password, and click OK. Select Database, Reindex and wait fo...