• Replace a Database in SSMS – SQL Instructions

  Follow the instructions in this article to properly replace a database in Microsoft SQL Server Management Studio (SSMS)

• Setting Up BreadCrumbs Server with SQL 2022 – Sigo Instructions

  Target Audience: EBI PRIVATEArticle #: 12693 Summary Follow the instructions in this article to set up a BreadCrumbs server. The process involves: Preparation Instructions Part 1: Install and Configure SQL Express More detailed instructions can be found here: Install and Configure SQL Express for BreadCrumbs Server – BreadCrumbs Instructions. Part 2: Install SQL Server Reporting Services…

• Create ODBC OLE Data Source for CODESOFT – Instructions

  In order to use the External Database feature TEKLYNX CENTRAL needs a data source created in CODESOFT to link it to the target database and the tables within. This article will guide you through the steps needed to set this up.

• Create a View from an External Table with a Record ID in TEKLYNX CENTRAL – Instructions

  Being able to use an external database in TEKLYNX CENTRAL to reduce the chance of human error requires that tables have Record IDs (UID). Instead of manually adding Record IDs to an existing database, you can create a virtual set.

• Configuring the External Database Feature – TEKLYNX CENTRAL Instructions

  Using an external database allows users to minimize human data entry errors by using an existing database to output their labels accurately.

• Backup a SQL Database to a File – SQL Server Instruction Article

  Open the instance of SQL with the database…

• SQL Query Typos – SQL Server Problem

  Often error message in SQL generate from typos in the SQL statement.  Long and complex queries are prone to small typos which will prevent the statement from executing. …

• Microsoft SQL Management Studio Will Not Allow Design Changes to a Database – SQL Server Problem

  User is blocked from making changes to Microsoft SQL database design. …

• Unable to Find an Instance of SQL Server on the Network (by Browsing) – SQL Server Problem

  Often while trying to use the browse function in SQL Management Studio or through a software application that is attempting to help a user to connect to a database instance, …

• “Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During the process…” – Microsoft Access Error

  Most likely the database has been corrupted. Access will attempt to trigger a rebuild as long as the file is not locked by another user or service. …