SQL Recommended Configuration - PayGlobal Database

SQL Recommended Configuration - PayGlobal Database

Summary

You can use any name for the PayGlobal SQL Server database, but we recommend that you name it ‘PayGlobal’.

Database Size

The default database size is 100 megabytes, with 10-megabyte log file.

The Log file will always be created with a size 10% of that of the data file.

Database Options

The PayGlobal database is set with the following options during setup:

SQL Server Options	Recommended Setting
Auto close	False
Bulk copy	False
Trunc. log on chkpt.	True
Torn page detection	True
Read only	False
DBO use	False
Single	False
Auto shrink	False
ANSI NULL default	False
Recursive triggers	False
ANSI nulls	False
Concat null yields null	False
Cursor close on commit	False
Default to local cursor	False
Quoted identifier	False
ANSI warnings	False
Auto create statistics	False
Auto update statistics	True

See also

SQL Database After Installing PayGlobal

SQL Recommended Configuration

SQL Server Authentication Process