Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Fix the driver behind crashes, sound loss and screen glitches3Repair Windows errors before they cause bigger problemsThe safest way to fix a TABLES.SYS error is to identify which object is actually failing before changing anything. In Microsoft Dynamics GP, the message may involve a damaged SQL table, corrupted stored-procedure resources in Procs.sys or Procs.cmp, missing support tables in SQL Server TEMPDB, or the physical tables.sys resource file. These are different failures with different repairs. First record the exact message and GP version, make verified backups, and then use the matching procedure below.
What TABLES.SYS means in Dynamics GP
Dynamics GP (formerly Great Plains) uses Dexterity and SQL resources to create and maintain company-database objects. Files such as tables.sys and procs.sys are installation resource files; they are not, by themselves, the data tables that hold your transactions. A TABLES.SYS message can therefore be a symptom rather than a precise diagnosis.
As an Amazon Associate I earn from qualifying purchases.
Typical messages say that GP cannot find a table, cannot create or open a table, cannot execute a procedure, or cannot log in. The failure may occur while GP starts, when a user logs in to a company, while posting, when opening a window, or during report generation. A separate login failure names DEX_LOCK or DEX_SESSION and points to SQL Server TEMPDB, not to a company table.
Do not delete or replace a SYS file, drop a SQL table, or run a script until you know which of these cases you have. Recreating the wrong object can remove data, break a customization, or leave all companies unable to start.
#1 Best Overall
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
Identify the failure before repairing it
Capture the exact error and context
- Copy the complete error text, including the table, procedure, database, or file name. Take a screenshot if the dialog truncates the message.
- Write down the GP release and build, the Windows computer where the client is running, the SQL Server instance, and the company database that fails.
- Record when it happens: GP startup, login, opening a particular window, posting, month-end, printing, or running a report.
- Ask whether every company and every user is affected, or only one company, one workstation, one window, or one third-party module.
- Check whether the message specifically names a physical
tables.sysorprocs.sysfile, a SQL object, a procedure,DEX_LOCK, orDEX_SESSION.
A table name in the message generally calls for SQL-object recreation through the Professional Services Tools Library (PSTL). A procedure or Procs.sys/Procs.cmp reference calls for the procedure-script method. DEX_LOCK and DEX_SESSION during login call for the dex_req.sql method. A missing or damaged resource file requires checking the GP installation and release-specific Microsoft guidance before attempting legacy resource extraction.
Back up and isolate the system first
Microsoft’s published procedures require users to be out of GP while objects are recreated. Treat the following as prerequisites, not optional precautions:
- Have every GP user exit all companies and confirm that no scheduled integration, reporting job, posting process, or service is still connected.
- Take a full SQL backup of the
DYNAMICSdatabase. - Take full backups of every company database that could be affected, not only the company named in the error.
- Make a separate backup copy of the GP code and installation folder, including the folders containing
tables.sys,procs.sys,Procs.cmp, and SQL utility scripts. - Verify that the backups can be read or restored to a test location. A backup that has never been checked is not a reliable rollback plan.
- Write down custom triggers, views, stored procedures, integrations, and third-party products that use the affected table. A table recreation can require those objects to be restored manually.
Use an account with the permissions required by the selected method. PSTL access is normally restricted to an administrator; the SQL script procedures require a SQL account permitted to alter the target databases, and the TEMPDB procedure is documented for an sa-level connection. If you cannot obtain those permissions, stop after backing up and involve your Dynamics GP support partner or a SQL Server consultant who works with GP.
Rank #2
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
Choose the repair path
| What the message identifies | Likely failure class | Primary repair | Data risk and special considerations |
|---|---|---|---|
| A named GP table cannot be found, opened, or created | Missing or damaged SQL table or table definition | PSTL Toolkit, Recreate SQL Objects | Enable data recreation when existing rows must remain. Custom triggers may need manual recreation. |
Procs.sys, Procs.cmp, or a stored procedure is missing or invalid |
Corrupted or missing stored-procedure resources | Run the matching procedure scripts in SQL Server Management Studio or Query Analyzer | Run against the correct company databases and DYNAMICS; script names and folders vary by GP release. |
DEX_LOCK or DEX_SESSION is absent during login |
Missing GP support tables in SQL Server TEMPDB |
Execute dex_req.sql from the GP installation folder |
Connect to the SQL Server instance with the documented administrative rights and run the script in the intended context. |
The physical tables.sys or procs.sys file is reported missing or damaged |
Installation resource-file problem | Check the GP installation, version, and Microsoft guidance; consider legacy extraction only as a last resort | Do not copy a SYS file from an unrelated GP release or workstation. |
Recreate a damaged SQL table with PSTL
For a message that identifies a GP table, Microsoft’s documented GUI route is the Professional Services Tools Library Toolkit. The exact series and table names depend on the installed GP release and modules.
Open the SQL-object recreation screen
- Start Dynamics GP with an administrator account after all other users have logged off.
- Open the Toolkit area in PSTL.
- Choose Recreate SQL Objects, then select Next.
- Select the series that owns the failing table. For example, a table used by purchasing belongs to a different series than one used by inventory or manufacturing.
- Select the specific table named in the error. Do not select an entire series unless Microsoft’s instructions for your release require it.
Preserve rows when they must remain
Before confirming the operation, select Recreate data for selected table(s) when the existing rows must be retained. Microsoft’s PSTL documentation states that marking this option recreates the table while leaving its data intact. If the option is left unmarked, PSTL recreates the table and the data is lost. The checkbox is therefore the critical data-preservation decision in this procedure.
- Choose Recreate Selected Table.
- Read the confirmation and maintenance messages. Do not interrupt GP or SQL Server while the object is being rebuilt.
- When the process completes, close and reopen the affected GP window, then test the original operation with a controlled record or inquiry.
- Check row counts and key records against the backup or a pre-maintenance report. Confirm that indexes, permissions, and application behavior are normal.
Account for custom triggers and integrations
PSTL recreates the selected SQL table, but a custom trigger attached to that table may not be restored automatically. Record the trigger definition before maintenance when possible, and have your database administrator verify it afterward. Also test integrations, reporting views, e-commerce feeds, and third-party windows that read or write the table. If the table was part of a customization, the customization vendor may need to reinstall its SQL objects after the base table is rebuilt.
Rank #3
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
If PSTL reports that it cannot recreate the object, stop rather than repeatedly retrying. Review the SQL error, confirm that the selected series and company are correct, and check that no user or service still holds a lock. A failed recreation is a reason to restore the backup or escalate, not to drop additional objects manually.
Recreate stored procedures with Procs.sys or Procs.cmp
Use this path when the error names a stored procedure or explicitly references Procs.sys or Procs.cmp. Microsoft’s procedure applies to GP 9.0-era and later releases, but Manufacturing and other earlier releases can use different script names and folders. Match every step to the release installed at your site.
Prepare the scripts
- Log every user out of GP and complete the database and code-folder backups described above.
- Locate
Procs.cmpand the relevantProcs.sysscripts in the GP installation or product folders. Do not use a script copied from another release. - Open SQL Server Management Studio (SSMS). Older environments may use SQL Server Query Analyzer, as described in the legacy Microsoft procedure.
- Read the script comments before executing anything. Where the script contains
%SysDBName%, replace that token with the exact target database name as instructed.
Run against each required database
Execute Procs.cmp against each affected company database, using the database selector or an explicit database context exactly as the release documentation specifies. Then execute the relevant Procs.sys scripts against the DYNAMICS database. If more than one company is installed, repeat the company-database step for each one that uses the affected module; a procedure restored in one company does not automatically repair another database.
Rank #4
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
- Review the SSMS results for errors after each script batch. Save the output so a consultant can see the first failure, not only the final message.
- Reconnect GP and test the operation that originally failed. Test both the affected company and a second company if the procedure is shared.
- Check custom procedures and triggers that depend on the rebuilt procedures. Reapply a customization only from its vendor’s documented script and only after the base GP objects work.
Do not improvise a procedure name or run every SQL file in a folder. Earlier releases, Manufacturing components, and localized installations can use different file layouts. If the script refers to a database that does not exist, or if execution produces conversion or permission errors, stop and verify the release-specific instructions with a GP administrator.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Repair missing DEX_LOCK or DEX_SESSION tables in TEMPDB
A GP login failure that specifically says DEX_LOCK or DEX_SESSION is missing is a separate SQL Server TEMPDB problem. Recreating a company table or replacing tables.sys will not fix it.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
- Confirm that the error occurs during GP login and names
DEX_LOCK,DEX_SESSION, or both. - Ensure users are out of GP and that you have a recent backup, even though this procedure targets support tables rather than company transaction tables.
- Connect to the SQL Server instance in SSMS using the administrative account required by the Microsoft procedure; the documented case uses
sa. - Find
dex_req.sqlin the GP installation folder. The documented default location is underSQLUtility, although the actual path can differ by release and installation choice. - Open the script in SSMS and execute it according to the script’s database instructions. Verify that the required support tables are created in the SQL Server
TEMPDBdatabase. - Have a test user log in to the affected company. If login succeeds, test posting or the window that originally exposed the problem.
TEMPDB is recreated by SQL Server when the instance restarts, so a change that appears to work can be lost after a restart if the underlying GP or SQL configuration is wrong. If the tables disappear again, capture the SQL Server version, startup behavior, and script output and escalate rather than repeatedly running the script without diagnosis.
Best Value
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
When the physical tables.sys file is missing or corrupt
If the message explicitly identifies the file on disk, first verify the GP client’s installation path, file permissions, antivirus quarantine history, and whether the file exists on a working GP workstation running the same release and build. A file from another release, language, or service-pack level can be incompatible even when its name is identical. Repair or reinstall the same GP build using your organization’s approved media and preserve the original folder for comparison.
A practitioner article published on October 2, 2008 describes adding duExtractSQLResources=TRUE to dex.ini to rebuild tables.sys and procs.sys. This is legacy, version-sensitive advice, not a universal fix. Use it only after backups, only after confirming that your GP release supports the setting, and only after checking current Microsoft guidance or your GP partner’s instructions. Do not add the setting blindly to a modern installation or treat a successful extraction as proof that the SQL objects are healthy.
Validate the repair and prevent a repeat
Functional checks
- Repeat the exact action that produced the error, not just GP startup.
- Open the affected inquiry or window, create a controlled test transaction, and reverse or remove the test according to your accounting controls.
- Run a relevant report and verify that totals and historical rows match a pre-maintenance report or backup.
- Test integrations, scheduled processes, and third-party windows that use the rebuilt table or procedure.
Technical checks
- Review SQL Server Agent and SSMS messages for errors from the maintenance window.
- Confirm that the rebuilt object has the expected name, columns, indexes, permissions, triggers, and row count.
- Check all company databases, not just the database used for the first test.
- Keep the pre-repair backups and script output until users have completed a normal posting and reporting cycle.
Escalate when the evidence does not fit
Stop and obtain specialist help when the error changes after each attempt, the table is part of a third-party product, a custom trigger is undocumented, the backup cannot be verified, or SQL reports corruption beyond the named object. Give the consultant the exact error, GP build, database names, backup status, script output, and a list of steps already performed. That information is more useful than a general request to “fix TABLES.SYS.”
PC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchQuick Recap
Common mistakes that make TABLES.SYS incidents worse
- Dropping the table first: this can permanently remove rows and does not preserve custom SQL objects.
- Leaving data recreation unchecked: PSTL then recreates the table without its existing data.
- Running scripts while users are connected: locks and concurrent writes can produce partial or misleading results.
- Using the wrong company or database: a procedure can succeed in SSMS while repairing the wrong environment.
- Copying SYS files between releases: resource formats and product components are version-sensitive.
- Treating every message as a file problem:
DEX_LOCKandDEX_SESSIONindicate TEMPDB support tables, while a named GP table generally calls for PSTL. - Ignoring custom triggers: the base table may work while an integration silently fails after recreation.
- Relying on an untested backup: without a restorable copy of DYNAMICS, company databases, and the code folder, recovery options are limited.
Optional shortcut after the manual checks
If you prefer an automated Windows-maintenance shortcut after completing the backups and diagnosis, Outbyte PC Repair can address more than 100 common Windows issues, including broken system elements, invalid redirects and shared DLL problems, while also offering cleanup, settings adjustments, vulnerability checks and an app-crash log. It runs on Windows 11, 10, 8 and 7 and includes a free trial of at least two days before a subscription; it complements antivirus software rather than replacing it, results vary, and no tool repairs every Dynamics GP or SQL failure.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
