http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2888]
PostgreSQL [103]
기타정보 [150]
운영체제 [577]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Work Book :: MS SQL

 회원가입

DB 정보, 엔진 Version , datafile 정보
최길호 [LIST]   2016-10-24 16:23:08, 조회 : 726

COMPATIBILITY_LEVEL {140 | 130 | 120 | 110 | 100 | 90 | 80}
Version               엔진,호환값,    [호환가능]
SQL Server 2017       :14   140   [ 140, 130, 120, 110, 100 ]
Azure SQL 데이터베이스:12   130   [ 140, 130, 120, 110, 100 ]
SQL Server 2016       :13   130   [ 130, 120, 110, 100 ]
SQL Server 2014       :12   120   [ 120, 110, 100 ]
SQL Server 2012       :11   110   [ 110, 100, 90 ]
SQL Server 2008 R2    :10.5 100   [ 100, 90, 80 ]
SQL Server 2008       :10   100   [ 100, 90, 80 ]
SQL Server 2005       :9    90    [ 90, 80 ]
SQL Server 2000       :8    80    [ 80 ]
https://docs.microsoft.com/ko-kr/sql/t-sql/statements/alter-database-transact-sql-compatibility-level


SELECT SERVERPROPERTY('ServerName') AS ServerName
, SERVERPROPERTY('MachineName') AS MachineName
, SERVERPROPERTY('InstanceName') AS InstanceName
, SERVERPROPERTY('Edition') AS Edition
, SERVERPROPERTY('ProductVersion') AS ProductVersion
, SERVERPROPERTY('ProductLevel') AS ProductLevel;
GO

-- DBNAME,DBSIZE
exec sp_databases
-- DBNAME,OWNER,사용언어,복구모드(SIMPLE,FULL),Size,MAX_Size
select d.name,u.name,collation_name,d.recovery_model_desc,f.size as 'DBFSIZE',f.max_size
from sys.databases d
left outer join sysusers u
on d.owner_sid = u.sid
inner join sys.master_files f
on d.database_id = f.database_id
where f.type_desc='ROWS'

-- data,log filename
SELECT
    db.name AS DBName,
    type_desc AS FileType,
    Physical_Name AS Location
FROM
    sys.master_files mf
INNER JOIN
    sys.databases db ON db.database_id = mf.database_id

-- HOSTNAME 변경
SELECT @@SERVERNAME;
GO
SELECT SERVERPROPERTY('ServerName')
GO

EXEC sp_dropserver 'WIN-NIGLTNOU963'
GO
EXEC sp_addserver 'DBSVR', 'local'
GO



  LIST

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
06/29
[ORACLE]
DDE: Problem Key 'ORA 600 [133....
by 최길호
06/25
[ORACLE]
Replication may not be valid i....
by 최길호
06/22
[운영체제]
CentOS7 홈페이지 Migration 메모.
by 최길호