Shunze ¾Ç¶é (http://www.shunze.info/forum/index.php)
|- ¸ê®Æ®wºÞ²z (http://www.shunze.info/forum/board.php?boardid=28)
|-- ¡m¤À¨É¡nMS SQL¸ê®Æ®wÁÙ­ì¨ì¥t¤@¥x¥D¾÷µLªkµn¤J (http://www.shunze.info/forum/threadid.php?boardid=28&threadid=1711)


§@ªÌ: shunze µoªí®É¶¡: 2013-04-21, 16:27:

¡m¤À¨É¡nMS SQL¸ê®Æ®wÁÙ­ì¨ì¥t¤@¥x¥D¾÷µLªkµn¤J

§âMS SQL Server Aùتº¸ê®Æ®wÁÙ­ì¨ìMS SQL Server B«á¡A
ÁöµM¸ê®Æ®w¦¨¥\ÁÙ­ì¤F¡A
¦ý­ì¥»¸ê®Æ®wªº­Ó§O±b¸¹«o¤£¯à¦bMS SQL Server BùبϥΡH

¶À©üªº¥Ì½©ùتº¦³²M·¡ªº¸Ñ»¡¡C
·N«ä¬O·í§Ú­Ì³Æ¥÷¸ê®Æ®w®É¡A¥´¥]ªº¥u¬O­Ó§O¸ê®Æ®wªº¸ê®Æ¡A
¥]¬A¦¹¸ê®Æ®wªº±b¸¹¡C

¦ý¾ãÅéSQL Serverªº¦w¥þ©Ê±b¸¹¡A¨Ã¨S¦³¤@°_¥´¥]°_¨Ó¡C
©Ò¥H·íÁÙ­ì¨ì·s¥D¾÷®É¡A
ÁöµM¸Ó¸ê®Æ®wªº©Ò¦³¸ê°T³£¦¨¥\ÁÙ­ì¤F¡A
¦ýSQL ServerùØ«o¤Ö¤F¹ïÀ³ªº¦w¥þ©Ê±b¸¹¡A
¦]¦¹¦¹¸ê®Æ®w­Ó§O±b¸¹µLªkµn¤J¨Ï¥Î¡I



¸Ñ¨M¤èªk¬O³z¹LStore Procedure¡Asp_change_users_login´N¥i¥H·d©w¡C

EXEC sp_change_users_login 'Auto_Fix', '±b¸¹', NULL, '±K½X';


°õ¦æ®É¡A¥²¶·¥ý±N°õ¦æ¥Ø¼Ð¿ï¨ì¹ïÀ³ªº¸ê®Æ®w¦WºÙ¡C



°õ¦æ§¹«á¡A´N¥i¥Hµo²{¸ê®Æ®wªº±b¸¹©MSQLªºµn¤J±b¸¹¤w¸g¤@­P¡C



¥B¸ê®Æ®wùتº±b¸¹¡A¨äµn¤JÄݩʤ]¹ïÀ³¨ì¥¿½Tªº¸ê®Æ®w¤F¡C

Powered by: Burning Board 1.1.1 2001 by WoltLab
Taiwan Translation by Achi