Shunze ¾Ç¶é >¹q¸£¸ê°T¾Ç¨t >¸ê®Æ®wºÞ²z > ¡m¤À¨É¡nMS SQL¸ê®Æ®wÁÙ­ì¨ì¥t¤@¥x¥D¾÷µLªkµn¤J «¢Åo¡AÁÙ¨S¦³µù¥U©ÎªÌµn¤J¡C½Ð§A[µù¥U|µn¤J]
« ¤W¤@½g¥DÃD ¤U¤@½g¥DÃD » Åã¥Ü¦¨¦C¦L¼Ò¦¡ | ¼W¥[¨ì§Úªº³Ì·R
µoªí·s¥DÃD µoªí¦^ÂÐ
§@ªÌ
¥DÃD
shunze
¤u¤Í§B§B


µù¥U¤é´Á: 2002 04
¨Ó¦Û: ¼é¦Á²×¤î¤§¦a
¤å³¹: 2370

shunze Â÷½u
¡m¤À¨É¡nMS SQL¸ê®Æ®wÁÙ­ì¨ì¥t¤@¥x¥D¾÷µLªkµn¤J¤Þ¥Î¦^ÂÐ ½s¿è/§R°£¤å³¹ ·j´M¥Ñ  µoªíªº¨ä¥L¤å³¹ ¦^³øµ¹ª©¥D IP ¦ì¸m ¦^¦¹­¶³Ì¤W¤è

§â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



♥¶¶¤l¦Ñ±Cªººô©ç¡A½Ð¦hÃö·Ó¡ã

If you don't like something, change it.
If you can't change it, change your attitude.
Don't complain!




2013-04-21, 16:27 shunze ªº­Ó¤H¸ê®Æ §â shunze ¥[¤J¦n¤Í¦Cªí µo°eEmailµ¹ shunze ÂsÄý shunze ªººô¯¸ MSN : shunze@gmail.com
  « ¤W¤@½g¥DÃD ¤U¤@½g¥DÃD »
µoªí·s¥DÃD µoªí¦^ÂÐ
¸õ¨ì:

Powered by: Burning Board 1.1.1 2001 WoltLab GbR