System Administrator Setup and Configuration
Below is code that could be used to find Last Table modified within manexSQL: SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,* FROM sys...
Wed, 29 Jun, 2022 at 3:33 PM
Below is a very common problem that could occur after a new install of SQL Server on a server. When you try to access it over the network, the following err...
Wed, 29 Jun, 2022 at 3:33 PM
Before starting, save a backup to prevent any data loss. If you have any questions regarding computer and database administration, contact the necessary per...
Wed, 29 Jun, 2022 at 3:34 PM
To restore a SQL DB from a backup, follow the steps below: 1. You should have received the backup file in a compressed format, and you will want to plac...
Wed, 29 Jun, 2022 at 3:34 PM
1. It is suggested to have a directory on your server for manex software. Within that directory, we also suggest to create the following sub-directories: ...
Tue, 23 Jan, 2024 at 1:11 PM
1. Create new directory called manexSql Note: You can name it something different, but the folder name cannot have any spaces in the name or it will not w...
Wed, 29 Jun, 2022 at 3:34 PM
Giving write permissions to all IIS_USRS group is a bad idea from a security standpoint, and is not necessary. Instead, provide permissions only to syste...
Thu, 30 Jun, 2022 at 1:12 PM
1. Check settings for an ODBC data source, which is usually found under one of the below pathways: 1.1 Start > Programs > Administrative Tools >...
Thu, 30 Jun, 2022 at 1:13 PM
Definition of Database Maintenance Plan: A database maintenance plan is a set of specific, proactive tasks that need to be performed regularly on database...
Thu, 30 Jun, 2022 at 1:13 PM
Prerequisites: in order to autorun MRP, a sqlautomrprun.exe file is required, which should already be located in the main manexSQL application directory on ...
Wed, 29 Jun, 2022 at 3:34 PM