System Administrator Setup and Configuration

Code That Could Be Used to Find Last Table Modified Within SQL
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
Configure SQL Server 2008 R2 to Allow Network Connections
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
How to Detach and Attach Databases Using the SQL Server Management Studio
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
Restore SQL Database (DB) from Backup
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
Set up a SQL Test/Sandbox Database
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
manexSQL Client Server Setup Instructions
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
Set up Folder Permissions to Write "ini" File
  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
Set up the ODBC for SQL Crystal Reports
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
Set up a SQL Database Maintenance Plan
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
Set up Task Scheduler to Autorun MRP
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