ÇöÀç MSSQL ÀÎÁõ¼¸¦ Á¡¼± ¾Æ·¡¿Í °°ÀÌ ¸¸µé¾ú´Âµ¥ ÀÌ·²°æ¿ì ÀÎÁõ¼ À̵¿ÀÌ ¾ÈµÈ´Ù³×¿ä
ÀÌ°Å ¾ÈÀüÇÏ°Ô ´Ù¸¥ ¼¹ö·Î ¿Å±æ ¼ö ÀÖ´Â ¹æ¹ýÀÌ ÀÖÀ»±î¿ä??
-------------------------------------------------------------------------------------------------
1.ÀÚü ¼¸íµÈ ÀÎÁõ¼ ¸¸µé±â
´ÙÀ½ ¿¹¿¡¼´Â Shipping04¶ó´Â ÀÎÁõ¼¸¦ ¸¸µì´Ï´Ù. ÀÌ ÀÎÁõ¼ÀÇ °³ÀÎ Å°´Â ¾ÏÈ£¸¦ »ç¿ëÇÏ¿© º¸È£µË´Ï´Ù.
USE AdventureWorks2012;
CREATE CERTIFICATE Shipping04
ENCRYPTION BY PASSWORD = 'pGFD4bb925DGvbd2439587y'
WITH SUBJECT = 'Sammamish Shipping Records',
EXPIRY_DATE = '20121031';
GO | |
|