DATENAME

http://www.littleworld.net/ai/kmod.asp?no=724&isn=&mymsg=

http://blog.naver.com/leonard21?Redirect=Log&logNo=20043055113

http://www.youtu.kr/106723

트렌젝션 로그파일이 미친듯이 커져서 압축해야할 경우
DBCC SHRINKFILE([논리적 db명 트랜젝션 로그 파일], 10)
위를 실행할 경우 안될 경우에는 아래와같이 Reconvery Rule 변경후 실행

sp_helpfile

ALTER DATABASE [DB명] SET RECOVERY SIMPLE

GO

DBCC SHRINKFILE([논리적 db명 트랜젝션 로그 파일], 10)

GO

ALTER DATABASE [DB명] SET RECOVERY FULL

set identity_insert dbo.event on

반듯이 아래와 같이 컬럼을 넣어줘야함

set identity_insert dbo.event off

관련 생성 쿼리

select 'set identity_insert dbo.' + b.name +' on '
, 'insert into ' + b.name + ' ( '+
 STUFF((SELECT ',' + name 
    
       FROM sys.columns B
       WHERE B.object_id = A.object_id
       FOR XML PATH('')
      ),1,1,'')
       + ' ) select * from [mesj].mes_sep.dbo.' +b.name + ' '
, 'set identity_insert dbo.' + b.name +' off '
 from sys.identity_columns a
inner join sys.tables b
on a.object_id = b.object_id

 int i = 0;

        foreach (SYS_FORM_MTSchema schema in Lists)

        {

            i++;

            ListItem item = new ListItem(schema.FORM_NM, schema.FORM_ID);

            item.Attributes.Add("title", schema.FORM_ID);

            ddlBP_ID.Items.Insert(i, item);

        }

 var e = document.getElementById("<%= ddlBP_ID.ClientID %>");

            var tooltip = e.options[e.selectedIndex].title;

SELECT  b.TABLE_NAME AS TABLE_NAME

        ,td.value AS TABLE_DESC

 , A.COLUMN_NAME

, A.DATA_TYPE

 + CASE WHEN A.DATA_TYPE IN ('nvarchar','char','nchar','varchar') THEN +'(' + CONVERT(NVARCHAR,CHARACTER_MAXIMUM_LENGTH) + ')'

  WHEN A.DATA_TYPE IN ('numeric','decimal') THEN CONVERT(NVARCHAR,NUMERIC_PRECISION) + ',' + CONVERT(NVARCHAR,NUMERIC_SCALE)

ELSE '' END AS DATA_TYPE

,CASE WHEN A.IS_NULLABLE = 'YES' THEN 'Null' ELSE 'Not Null' END AS IS_NULLABLE 

, CASE WHEN C.TABLE_NAME IS NOT NULL THEN 'PK' ELSE '' END PK

 , ISNULL(COLUMN_DEFAULT,'') AS COLUMN_DEFAULT

, CASE WHEN B.DESCRIPTION IS NULL THEN '' ELSE B.DESCRIPTION END AS DESCRIPTION 

FROM INFORMATION_SCHEMA.COLUMNS A

LEFT OUTER JOIN (SELECT a.object_id AS TABLE_ID, a.name AS TABLE_NAME, b.name AS COLUMN_NAME, b.column_id AS COLUMN_ID, c.value AS DESCRIPTION

FROM sys.objects a

 LEFT JOIN sys.columns b ON a.object_id=b.object_id

 LEFT JOIN sys.extended_properties c ON (a.object_id=c.major_id AND b.column_id=c.minor_id)

) B

ON A.TABLE_NAME = B.TABLE_NAME

AND A.COLUMN_NAME = B.COLUMN_NAME

LEFT OUTER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE C

ON A.TABLE_NAME = C.TABLE_NAME

AND A.COLUMN_NAME = C.COLUMN_NAME

LEFT JOIN sys.extended_properties td

  ON td.major_id = b.TABLE_ID

AND td.minor_id = 0

AND td.name = 'MS_Description'

WHERE A.TABLE_NAME LIKE '%CRM_Learning%'