Buildmasters Legacy Database Documentation
Server
DVROEE20BASE
Server
DVROEE20BASE
Server Properties
| Name | Value |
| Code Page | 1252 |
| Network Name | DVROEE20TH |
| Language | us_english |
| Service Name | MSSQLSERVER |
| Instance Name | |
| Collation | SQL_Latin1_General_CP1_CI_AS |
| Is Clustered |  |
| Is Full Text Search Installed |  |
Version
| Microsoft SQL Server 2005 - 9.00.3159.00 (X64) Mar 23 2007 20:11:35 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) |
Databases
| Database | Owner | System | |
 |
AciTransformationServices | DVROEE20TH\vmadmin | |
|
ARCH_CTRLCTR | DVROEE20TH\vmadmin | |
|
BBDW | DVROEE20TH\vmadmin | |
|
CASH | DVROEE20TH\vmadmin | |
|
CTRLCTR | DVROEE20TH\vmadmin | |
|
DATAEXCH | DVROEE20TH\vmadmin | |
|
DATAMART | DVROEE20TH\vmadmin | |
|
DMPMetadata | DVROEE20TH\vmadmin | |
|
EagleGatewayConfig | DVROEE20TH\vmadmin | |
|
EagleGatewayPreStage | DVROEE20TH\vmadmin | |
|
EagleGatewayStage | DVROEE20TH\vmadmin | |
|
EAGLEKB | DVROEE20TH\vmadmin | |
|
EAGLEMGR | DVROEE20TH\vmadmin | |
|
ESTAR | DVROEE20TH\vmadmin | |
|
HOLDING | DVROEE20TH\vmadmin | |
|
LEDGER | DVROEE20TH\vmadmin | |
|
master | sa | |
|
model | sa | |
|
msdb | sa | |
|
MSGCENTER | DVROEE20TH\vmadmin | |
|
Northwind | DVROEE20TH\vmadmin | |
|
PACE_MASTER | DVROEE20TH\vmadmin | |
|
PERFORM | DVROEE20TH\vmadmin | |
|
PRICING | DVROEE20TH\vmadmin | |
|
RoeeSsis2a | DVROEE20TH\vmadmin | |
|
RULES | DVROEE20TH\vmadmin | |
|
SCRUB | DVROEE20TH\vmadmin | |
|
SECURITY | DVROEE20TH\vmadmin | |
|
tempdb | sa | |
|
TRADES | DVROEE20TH\vmadmin | |
Server Configuration
| Parameter Name | Value |
| affinity I/O mask | 0 |
| affinity mask | 0 |
| affinity64 I/O mask | 0 |
| affinity64 mask | 0 |
| Allow cross db ownership chaining | 0 |
| Allow recursion for server level triggers | 1 |
| Allow remote access | 1 |
| Allow triggers to be invoked within triggers | 1 |
| Allow updates to system tables | 0 |
| AWE enabled in the server | 0 |
| Blocked process reporting threshold | 0 |
| c2 audit mode | 0 |
| CLR user code execution enabled in the server | 1 |
| Common Criteria compliance mode enabled | 0 |
| cost threshold for parallelism | 5 |
| Create DTC transaction for remote procedures | 0 |
| cursor threshold | -1 |
| DB connection timeout for full-text protocol handler (s) | 60 |
| Dedicated Admin Connections are allowed from remote clients | 1 |
| Default fill factor percentage | 0 |
| default full-text language | 1033 |
| default language | 0 |
| Disallow returning results from triggers | 0 |
| Enable or disable Ad Hoc Distributed Queries | 0 |
| Enable or disable Agent XPs | 0 |
| Enable or disable command shell | 0 |
| Enable or disable Database Mail XPs | 0 |
| Enable or disable Ole Automation Procedures | 0 |
| Enable or disable Replication XPs | 0 |
| Enable or disable SMO and DMO XPs | 1 |
| Enable or disable SQL Mail XPs | 0 |
| Enable or disable the default trace | 1 |
| Enable or disable Web Assistant Procedures | 0 |
| Max number of full-text crawl buffers | 100 |
| Max number of full-text notifications buffers | 100 |
| Maximum crawl ranges allowed in full-text indexing | 4 |
| maximum degree of parallelism | 0 |
| Maximum estimated cost allowed by query governor | 0 |
| Maximum recovery interval in minutes | 0 |
| Maximum size of a text field in replication. | 65536 |
| Maximum size of server memory (MB) | 3000 |
| maximum time to wait for query memory (s) | -1 |
| Maximum worker threads | 0 |
| Memory for index create sorts (kBytes) | 0 |
| minimum memory per query (kBytes) | 1024 |
| Minimum size of server memory (MB) | 0 |
| Network packet size | 4096 |
| Number of locks for all users | 0 |
| Number of open database objects | 0 |
| Number of reserved full-text crawl buffers | 0 |
| Number of reserved full-text notifications buffers | 0 |
| Number of user connections allowed | 0 |
| Priority boost | 0 |
| Recovery policy for DTC transactions with unknown outcome | 0 |
| remote login timeout | 20 |
| remote query timeout | 600 |
| scan for startup stored procedures | 0 |
| set working set size | 0 |
| show advanced options | 0 |
| Tape retention period in days | 0 |
| Transform noise words for full-text query | 0 |
| two digit year cutoff | 2049 |
| Use precomputed rank for full-text query | 0 |
| User mode scheduler uses lightweight pooling | 0 |
| user options | 0 |
See also