mssqlÀïµÄÕâЩÓû§ÊǸÉÂïµÄ£¬Ó¦¸Ãɾ³ý»¹ÊǾܾø·ÃÎÊ£¿
sql 2005ÀïÓÐЩ2000ÀïûÓеÄÓû§£¬²»ÖªµÀ·Ö±ðÓÐʲô¹¦ÄÜ£¿
³öÓÚ°²È«¿¼ÂÇ£¬ÄÄЩӦ¸Ãɾ³ýÄÄЩӦ¸Ã¾Ü¾ø·ÃÎÊ£¿
лл£¡
BUILTIN\Administrators
BUILTIN\Users
NT AUTHORITY\SYSTEM
xxxx\SQLServer2005MSSQLUser$xxxx$SQLEXPRESS
##MS_AgentSigningCertificate##
INFORMATION_SCHEMA
ѧϰ`
BUILTIN\Administrators
BUILTIN\Users
ÕâЩÊÇÓû§×é°É
ÔÚ°²×°SQL Server 2000 £¬°²×°½ø³Ì×Ô¶¯µØΪBUILTIN\Administrators”´´½¨Ò»¸öµÇ¼Õʺţ¬¸ÃÕʺÅΪsysadmin”½ÇÉ«³ÉÔ±¡£BUILTIN\Administrators”µÇ¼ÕʺŴú±íÁËMicrosoft Window2000 ÉϵÄϵͳ¹ÜÀíÔ±±¾µØ×é¡£ Windows 2000µÄAdministrator”ÕÊ»§ÊÇϵͳ¹ÜÀíÔ±±¾µØ×éµÄ³ÉÔ±¡£
´ËÍ⣬Èç¹ûÄúµÄ·þÎñÆ÷ÊÇÒ»¸öÓòµÄ³ÉÔ±£¬Domain Admins”È«¾Ö×éÒ²»á³ÉΪ±¾µØϵͳ¹ÜÀíÔ±×éµÄ³ÉÔ±¡£ÕâÒâζ×Åϵͳ¹ÜÀíÔ±±¾µØ×éµÄËùÓгÉÔ±¶¼»á×Ô¶¯µØ»ñµÃSQL ServerÉϵÄsysadmin”ȨÏÞ¡£ÎªÁ˼ÓÇ¿ÄúµÄSQL ServerµÄ°²È«ÐÔ£¬¿ÉÒÔ´´½¨×Ô¼ºµÄ×é²¢ÊÚÓèËüsysadmin”ȨÏÞ£¬È»ºóɾ³ýBUILTIN\Administrators”µÇ¼Õʺţ¬»òÕßÖÁÉÙ´Ósysadmin”·þÎñÆ÷½ÇÉ«ÖÐɾ³ýËü¡£Ê¹ÓÃÕâÖÖ·½·¨£¬¿ÉÒԽϺõضÔË¿ÉÒÔ·ÃÎÊÄúµÄSQL Server½øÐпØÖÆ¡£ÕâÖÖ·½·¨Ò²¶Ï¿ªÁËSQL Server ϵͳ¹ÜÀíÔ±ºÍWindows 2000 ¹ÜÀíÔ±Ö®¼äµÄÁªÏµ£¬ÒòΪËûÃÇͨ³£Óв»Í¬µÄÈÎÎñ£¬²¢ÇÒÐèÒª²»Í¬µÄȨÏÞ¡£ÎªÁ˼ÓÇ¿°²È«ÐÔ£¬Äú¿ÉÄÜÏë°ÑSQL ServerÅäÖóÉÖ»Ö§³ÖWindowsÉí·ÝÑéÖ¤¡£µ«ÊÇ£¬±ØÐëÒª¼Çס£ºÕâÖÖÅäÖûá½ûÓÃÄúµÄsa”ÕÊ»§¡£Èç¹ûÄúÒÔ´íÎóµÄ˳ÐòʵʩÁËÕâ¸ö°²È«´ëÊ©£¬Äú½«²»ÄÜÔÙÒÔ>sysadmin”µÄÉí·ÝµÇ¼µ½SQL ServerÉÏ£¬³ý·
Ïà¹ØÎÊ´ð£º
¸÷λ´óÏÀ£¬ÔÚsql server2000 ÖУ¬ÈçºÎµ¼Èë±í£¬ËûÀïÃæµÄ½á¹¹¶¼²»·¢Éú±ä»¯£¬ÏñË÷Òý£¬Ö÷¼üµÈ»¹ÊÇÔÀ´±íÀïµÄÉèÖã¬Èç¹ûÉú³Ésql½Å±¾µÄ»°£¬ÔÚ²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐÒ»´Î£¬Ö÷¼üË÷Òý¶¼Ã»ÁË£¬ÓÐûÓкõİ취
±¸·Ý»¹Ô»òÕ߸½¼ÓÊÇΨ ......
Çë¿´ÒÔÏÂÀý×Ó Ð»Ð»£¡
Àý×Ó
A(×Ö¶Î)
------------------------
a b c
ab c
f c d
½á¹û:
A(×Ö¶Î)
------------------------È ......
MSSQL$SQLEXPRESS ÎÞ·¨Æô¶¯.. ÖªµÀÈçºÎ´¦ÀíµÄÇë°ï°ïæ лл
¿´¿´´íÎóÈÕÖ¾
Ìáʾʲô´íÎó?
http://blog.csdn.net/fredrickhu/archive/2009/09/20/4573408.aspx
......
_RecordsetPtr pRs("ADODB.Recordset");
"provider=SQLOLEDB;Data Source=»úÆ÷Ãû\\SQLEXPRESS;Persist Security Info=False;User ID=sa;PWD=sa;initial catalog ......
Ä¿Ç°ÓбíAºÍ±íB
ÆäÖÐ×Ö¶ÎÏàͬ
±íAÖÐÖ÷¼üidΪ×ÔÔö³¤
²¢ÇÒΪ´óÊý¾ÝÁ¿´¢´æ
ÔõôÑùʹÓô洢¹ý³Ì¿ÉÒÔ½«±íAÖеÄÊý¾Ý±¸·Ýµ½±íBÖУ¬²¢ÇÒɾ³ý±íAÖб¸·Ý¹ýµÄÊý¾Ý
¸ßÊÖ¸øÒ»¸ö´æ´¢¹ýÊ££¬Ð»Ð»
·ÖÇø±í¿ÉÒÔ½«±íÖÐµÄ ......