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)