Find SQL Server Version
exec sys.sp_server_info;
| attribute_name | attribute_value |
|---|---|
| DBMS_NAME | Microsoft SQL Server |
| DBMS_VER | Microsoft SQL Server 2012 - 11.0.2100.60 - 11.0.2100.60 |
| OWNER_TERM | owner |
| TABLE_TERM | table |
| MAX_OWNER_NAME_LENGTH | 128 |
| TABLE_LENGTH | 128 |
| MAX_QUAL_LENGTH | 128 |
| COLUMN_LENGTH | 128 |
| IDENTIFIER_CASE | MIXED |
| TX_ISOLATION | 2 |
| COLLATION_SEQ | charset=iso_1 collation=Latin1_General_CI_AI |
| SAVEPOINT_SUPPORT | Y |
| MULTI_RESULT_SETS | Y |
| ACCESSIBLE_TABLES | Y |
| USERID_LENGTH | 128 |
| QUALIFIER_TERM | database |
| NAMED_TRANSACTIONS | Y |
| SPROC_AS_LANGUAGE | Y |
| ACCESSIBLE_SPROC | Y |
| MAX_INDEX_COLS | 16 |
| RENAME_TABLE | Y |
| RENAME_COLUMN | Y |
| DROP_COLUMN | Y |
| INCREASE_COLUMN_LENGTH | Y |
| DDL_IN_TRANSACTION | Y |
| DESCENDING_INDEXES | Y |
| SP_RENAME | Y |
| REMOTE_SPROC | Y |
| 500 SYS_SPROC_VERSION | 11.00.2100 |
Tags:SQL Server version,Find SQL Server Version,Find SQL Server Current Database,Find SQL Server Current User,Find SQL Server Server Version,Find SQL Server Protocol Version,Find SQL Server Connection,Find SQL Server Server characterset,Find SQL Server DB characterset,Find SQL Server client Characterset,find SQL Server Client Character Set,Find SQL Server port,Find SQL Server Uptime.
No comments:
Post a Comment