Databases
1Properties
| Name | Value |
|---|---|
| Product | Microsoft SQL Server |
| Version Level | RTM |
| Edition | Enterprise Edition (64-bit) |
| Version | 11.0.2100.60 |
| Language | English (United States) |
| Collation | SQL_Latin1_General_CP1_CI_AS |
| Platform | NT x64 |
| OS Version | 6.2 (9200) |
| Processors | 4 |
| Physical Memory (Mb) | 3989 |
| Clustered | False |
| Root Directory | E:\sqlserver_data_files\MSSQL11.BINJAVA018\MSSQL |
Settings
| Name | Value |
|---|---|
| Default data file path | E:\sqlserver_data_files\MSSQL11.BINJAVA018\MSSQL\DATA\ |
| Default log file path | E:\sqlserver_data_files\MSSQL11.BINJAVA018\MSSQL\DATA\ |
| Default backup file path | E:\sqlserver_data_files\MSSQL11.BINJAVA018\MSSQL\Backup |
| Recovery Interval (minutes) | 0 |
| Default index fill factor (%) | 0 |
| Default backup media retention (days) | 0 |
| Compress backup | False |
| Nested triggers enabled | True |
| Allow triggers to fire others | True |
| Default language | us_english |
| Default fulltext language | us_english |
| Default fulltext language LCID | 1033 |
| Network packet size | 4096 |
| Two digit year cutoff | 2049 |
| Max text replication size (bytes) | 65536 |
| Locks | 0 |
| Blocked process threshold | 0 |
| Cursor threshold | -1 |
| Cost threshold for parallelism | 5 |
| Scans and runs startup procedures | False |
| Transform noise words | False |
| Filestream access level | Disabled |
| Optimize for 'ad hoc' workloads | True |
| Remote login timeout (sec) | 10 |