Várias informações do seu servidor

Mais informações detalhadas sobre seu servidor:

Select
SERVERPROPERTY('BuildClrVersion') BuildClrVersion,
SERVERPROPERTY('Collation') Collation,
SERVERPROPERTY('CollationId') CollationId,
SERVERPROPERTY('ComparisonStyle') ComparisonStyle,
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') ComputerNamePhysicalNetBIOS,
SERVERPROPERTY('Edition') Edition,
SERVERPROPERTY('EditionID') EditionID,
SERVERPROPERTY('EngineEdition') EngineEdition,
SERVERPROPERTY('InstanceName') InstanceName,
SERVERPROPERTY('IsClustered') IsClustered,
SERVERPROPERTY('IsFullTextInstalled') IsFullTextInstalled,
SERVERPROPERTY('IsIntegratedSecurityOnly') IsIntegratedSecurityOnly, SERVERPROPERTY('IsSingleUser') IsSingleUser,
SERVERPROPERTY('LCID') LCID,
SERVERPROPERTY('LicenseType') LicenseType,
SERVERPROPERTY('MachineName') MachineName,
SERVERPROPERTY('NumLicenses') NumLicenses,
SERVERPROPERTY('ProcessID') ProcessID,
SERVERPROPERTY('ProductVersion') ProductVersion,
SERVERPROPERTY('ProductLevel') ProductLevel,
SERVERPROPERTY('ResourceLastUpdateDateTime') ResourceLastUpdateDateTime,
SERVERPROPERTY('ResourceVersion') ResourceVersion,
SERVERPROPERTY('ServerName') ServerName,
SERVERPROPERTY('SqlCharSet') SqlCharSet,
SERVERPROPERTY('SqlCharSetName') SqlCharSetName,
SERVERPROPERTY('SqlSortOrder') SqlSortOrder,
SERVERPROPERTY('SqlSortOrderName') SqlSortOrderName,
SERVERPROPERTY('FilestreamShareName') FilestreamShareName,
SERVERPROPERTY('FilestreamConfiguredLevel') FilestreamConfiguredLevel,
SERVERPROPERTY('FilestreamEffectiveLevel') FilestreamEffectiveLevel
GO


A xp_msver retorna:

ProductName
ProductVersion
Language
Platform
Comments
CompanyName
FileDescription
FileVersion
InternalName
LegalCopyright
LegalTrademarks
OriginalFilename
PrivateBuild
SpecialBuild
WindowsVersion
ProcessorCount
ProcessorActiveMask
ProcessorType
PhysicalMemory
Product ID

exec master..xp_msver
GO



A sp_helpserver retorna entre outras informações o collation do banco, sempre o id=0 é seu banco atual

exec master..sp_helpserver


A sp_server_info retorna:

DBMS_NAME
DBMS_VER
OWNER_TERM
TABLE_TERM
MAX_OWNER_NAME_LENGTH
TABLE_LENGTH
MAX_QUAL_LENGTH
COLUMN_LENGTH
IDENTIFIER_CASE
TX_ISOLATION
COLLATION_SEQ
SAVEPOINT_SUPPORT
MULTI_RESULT_SETS
ACCESSIBLE_TABLES
USERID_LENGTH
QUALIFIER_TERM
NAMED_TRANSACTIONS
SPROC_AS_LANGUAGE
ACCESSIBLE_SPROC
MAX_INDEX_COLS
RENAME_TABLE
RENAME_COLUMN
DROP_COLUMN
INCREASE_COLUMN_LENGTH
DDL_IN_TRANSACTION
DESCENDING_INDEXES
SP_RENAME
REMOTE_SPROC
SYS_SPROC_VERSION


exec master..sp_server_info