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ÉÏ£¬³ý·
Ïà¹ØÎÊ´ð£º
Ôõô»¹Ã»³öÀ´£¿£¿
ËÔÚ͵ÀÁÂð£¿!
Íê±Ï¡£
1
SF
3
bd
ûÁË
00
還ÒÔ為ÊÇÐÂ聞~~
ÒýÓÃ
還ÒÔ為ÊÇÐÂ聞~~
w
...
..
ÒýÓÃ
ű ......
¸÷λ´óÏÀ£¬ÔÚsql server2000 ÖУ¬ÈçºÎµ¼Èë±í£¬ËûÀïÃæµÄ½á¹¹¶¼²»·¢Éú±ä»¯£¬ÏñË÷Òý£¬Ö÷¼üµÈ»¹ÊÇÔÀ´±íÀïµÄÉèÖã¬Èç¹ûÉú³Ésql½Å±¾µÄ»°£¬ÔÚ²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐÒ»´Î£¬Ö÷¼üË÷Òý¶¼Ã»ÁË£¬ÓÐûÓкõİ취
±¸·Ý»¹Ô»òÕ߸½¼ÓÊÇΨ ......
ÔÚms sqlserverÖУ¬È¡Âú×ãÌõ¼þµÄǰ¼¸ÐпÉÒÔʹÓÃselect topÓï¾ä£¬µ«ÔÚoracleÖв¢Ã»ÓÐÕâÑùµÄÓï¾ä£¬
ÎÒ´ÓÍøÉÏ¿´µ½ÁËÒ»ÖÖʵÏÖ
select * (select * from talbename) where rownum <=100 order by rownum as ......
ÆäÖÐÒ»¸öoracleÊý¾Ý¿âÖÐÆäÖÐÒ»¸ö±íÓжà¸öʱ¼ä´Á×Ö¶Î,mssqlÖ»ÄÜÔÊÐíÒ»¸öµÄ.
ʵÔÚÓÐÎÊÌâµÄ»°£¬ ¿ÉÒÔÏȽ¨Á¢ÁíÍâµÄÒ»ÕÅ±í£¬È»ºó°Ñtimestamp¸ÄΪdate£¬°ÑÊý¾Ý¸´ÖÆÒÔºó£¬ÔÚÒÆÖ²Ò»´Î
oracleµÄʱ¼ä´ÁºÏ²¢ÎªÒ»¸ö×ֶα ......
mssql ÀïµÄsystem_user ÔÚoracleÀïÓÐʲôµÈ¼Ûº¯Êý£¿
system_userÊä³öÊǵÄʲô£¿
µ±Ç°²Ù×÷µÄÓû§£¬ÄãÓÃʲôµÇ¼SQL Query Analyzer ¾ÍÊÇʲô
²»Á˽âmsqsl£¬Õâ¸öº¯ÊýÊÇÈ¡µ±Ç°Á¬½ÓuserµÄÂð£¿
Èç¹ûÊǵϰ ......