Description
Properties
| Name | Value |
|---|---|
| SQL Server version | Microsoft SQL Server RTM 16.0.1000.6 |
| Edition | N/S |
| Compatibility level | |
| Last backup time | N/A |
| Last backup time of transaction log | N/A |
| Default index fill factor (%) | 80 |
| Creation date | 3/6/2025 6:55:13 PM |
| Number of Users | 4 |
| Database Encryption Enabled | False |
| Database Encryption Algorithm | N/A |
| Database status | ONLINE |
| Max size | 0 B |
| Database size (Mb) | 144 |
| Unallocated data space (Mb) | 61.31 |
| Default language | N/A |
| Default fulltext language | us_english |
Object Types
3Options
| Name | Value |
|---|---|
| Database collation | SQL_Latin1_General_CP1_CI_AS |
| Restrict access | MULTI_USER |
| Cleanly shutdown | False |
| Supplemental logging enabled | False |
| Is Read-Only | False |
| Auto close | False |
| Auto shrink | False |
| Database is read-only for restore log | False |
| Is Snapshot | False |
| Snapshot isolation state | False |
| Read committed snapshot on | False |
| Recovery model | SIMPLE |
| Page verify option | Checksum |
| Auto create statistics | True |
| Auto update statistics | True |
| Auto update statistics asynchronously | False |
| ANSI NULL default | False |
| ANSI NULL enabled | False |
| ANSI padding enabled | False |
| ANSI warnings enabled | False |
| Arithmetic abort enabled | False |
| Concatenating NULL yields NULL | False |
| Numeric roundabort enabled | False |
| Quoted Identifier ON | False |
| Recursive triggers enabled | False |
| Close cursors on commit | False |
| Local cursor by default | False |
| Fulltext enabled | True |
| Trustworthy | False |
| Database chaining | False |
| Forced parameterization | False |
| Master key encrypted by server | False |
| Published | False |
| Merge published | False |
| Is distribution database | False |
| Sync with backup | False |
| Service broker GUID | 0325803c-410c-4fec-ac33-006aac98d170 |
| Service broker enabled | False |
| Log reuse wait | Nothing |
| Date correlation | False |
| Change data capture enabled | False |
| Honor broker priority | False |
| Database owner | sa |
| Delayed durability | Disabled |
| Containment type | False |
Database Files
2| Name | Type | Size | Max size | Autogrowth | File Name |
|---|---|---|---|---|---|
| FideDoc | Rows | 73,728 KB | N/A | 65,536 KB | D:\SQL_Data\MSSQL16.MSSQLSERVER\MSSQL\DATA\FideDoc.mdf |
| FideDoc_log | Log | 73,728 KB | 2,147,483,648 KB | 65,536 KB | E:\SQL_logs\FideDoc_log.ldf |