출처 : http://support.microsoft.com/?kbid=288577

SQL Server에서 데이터베이스 유지 관리 계획을 사용할 때 발생하는 문제를 해결하는 방법

sqlagent.exe -c -v

sqlagent.exe -i[Instance] -c -v

출처 : http://support.microsoft.com/kb/237604/ko

PRB: SQL Server 에이전트가 시작되지 않고 오류 18456이 나타난다

출처 : http://doc.ddart.net/mssql/sql2000/html/tsqlref/ts_ca-co_5ell.htm

SQL Collation Name

A single string that specifies the collation name for a SQL collation.

Syntax

< SQL_collation_name > :: =

    SQL_SortRules[_Pref]_CPCodepage_<ComparisonStyle>

    <ComparisonStyle> ::=
        _CaseSensitivity_AccentSensitivity | _BIN

Arguments

SortRules

A string identifying the alphabet or language whose sorting rules are applied when dictionary sorting is specified. Examples are Latin1_General or Polish.

Pref

Specifies uppercase preference.

Codepage

Specifies a one to four digit number identifying the code page used by the collation. CP1 specifies code page 1252, for all other code pages the complete code page number is specified. For example, CP1251 specifies code page 1251 and CP850 specifies code page 850.

CaseSensitivity

CI specifies case-insensitive, CS specifies case-sensitive.

AccentSensitivity

AI specifies accent-insensitive, AS specifies accent-sensitive.

BIN

Specifies the binary sort order is to be used.

Remarks

This table lists the SQL collation names.

¹For Sort Order ID 80, use any of the Window collations with the code page of 1250, and binary order. For example: Albanian_BIN, Croatian_BIN, Czech_BIN, Romanian_BIN, Slovak_BIN, Slovenian_BIN.

See Also

aaa                 bbb

--------          --------

a   b   c           a   b   c

--------          --------

1   1   1            3   3   3

2   2   2            4   4   4

3   3   3            5   5   5

--------          --------

>> 합집합

select * from aaa

union

select * from bbb

-> 결과

1   1   1

2   2   2

3   3   3

4   4   4

5   5   5

>> 교집합 (inner join 가능)

select * from aaa

where exists

(select * from bbb where aaa.c = bbb.c)

>> SQL 2005 이상은 INTERSECT 사용 가능

select * from aaa

intersect

select * from bbb

-> 결과

3   3   3

>> 차집합 (outer join 가능)

select * from aaa

where not exists

(select * from bbb where aaa.c = bbb.c)

>> SQL 2005 이상은 EXCEPT 사용 가능

select * from aaa

except

select * from bbb

-> 결과

1   1   1

2   2   2

>> 합집합 - 교집합

select * from aaa where c not in (select aaa.c from aaa, bbb where bbb.c = aaa.c)
union
select * from bbb where c not in (select bbb.c from aaa, bbb where bbb.c = aaa.c)

>> SQL 2005 이상은 EXCEPT, INTERSECT 사용 가능

(select * from aaa
union
select * from bbb)
except

(select * from aaa

intersect

select * from bbb)

-> 결과

1   1   1

2   2   2

4   4   4

5   5   5