Shunze ¾Ç¶é >¹q¸£¸ê°T¾Ç¨t >¸ê®Æ®wºÞ²z > ¡m¤À¨É¡n§R¤£±¼ªº¸ê®Æ®w¨Ï¥ÎªÌ «¢Å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¤À¨É¡n§R¤£±¼ªº¸ê®Æ®w¨Ï¥ÎªÌ¤Þ¥Î¦^ÂÐ ½s¿è/§R°£¤å³¹ ·j´M¥Ñ  µoªíªº¨ä¥L¤å³¹ ¦^³øµ¹ª©¥D IP ¦ì¸m ¦^¦¹­¶³Ì¤W¤è

¦b «O­ô ªººô¯¸¤W¬Ý¨ì¡§SQL Server ¦w¥þ©Ê·§½×»PµLªk§R°£¸ê®Æ®w¨Ï¥ÎªÌªº¸Ñ¨M¿ìªk¡¨³o½g¡A
¬ðµM·Q¨ì¥H«e¦bSQLùؽT¹ê¦³¹J¨ì¹L¦¹²{¶H¡C
¥´ÅK¶X¼ö¡A»°§Ö¨ì¸ê®Æ®w¤¤«õÄ_§a¡ã

ªG¤£¨äµM¡A¹ï¸ê®Æ®w¤£¬O«Ü¼ôªº¶¶¤l¡A
¶}¥X¨Óªº¸ê®Æ®w¡AªGµM´N¦³³o­Ó²{¶H¦s¦b¡C


¥Ñ©ó³o­Ó¨Ï¥ÎªÌ±b¸¹³]©w¤F¼Æ­Ó¾Ö¦³ªºµ²ºc´y­z¡C


©Ò¥H¦b§R°£¦¹±b¸¹®É¡A´N·|¥X²{¦p«O­ô©Ò»¡ªº±b¸¹µLªk§R°£ªºª¬ªp¡C
¸ê®Æ®w¥DÅé¦b¸ê®Æ®w¤¤¾Ö¦³ µ²ºc´y­z ¥BµLªk¨ø°£¡C¿ù»~½X¬°15138¡C


¨Ì·Ó«O­ô´£¨ÑªºT-SQL¨Ó°õ¦æ¡A¤]½T¹ê¦C¥X¤F³o¼ËªºÃö«Y¡C

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA




³Ì«á·íµM¤]¬O¨Ì«O­ôªº±Ð¾Ç¡A
±N©Ò¦³¤£¸ÓÄݩ󦹨ϥΪ̪ºµ²ºc´y­z¡A²¾Â൹¹w³]±b¸¹¡A¸Ñ¨M¤F¦¹¾x¼@¡ã
ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [dbo]
ALTER AUTHORIZATION ON SCHEMA::[db_accessadmin] TO [db_accessadmin]
ALTER AUTHORIZATION ON SCHEMA::[db_securityadmin] TO [db_securityadmin]
ALTER AUTHORIZATION ON SCHEMA::[db_ddladmin] TO [db_ddladmin]
ALTER AUTHORIZATION ON SCHEMA::[db_backupoperator] TO [db_backupoperator]
ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [db_datareader]
ALTER AUTHORIZATION ON SCHEMA::[db_datawriter] TO [db_datawriter]



♥¶¶¤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-09-24, 23:05 shunze ªº­Ó¤H¸ê®Æ §â shunze ¥[¤J¦n¤Í¦Cªí µo°eEmailµ¹ shunze ÂsÄý shunze ªººô¯¸ MSN : shunze@gmail.com
shunze
¤u¤Í§B§B


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

shunze Â÷½u
¨Ï¥ÎªÌ¦b¸ê®Æ®w¤¤¾Ö¦³µ²ºc´y­z¡AµLªk§R°£¤Þ¥Î¦^ÂÐ ½s¿è/§R°£¤å³¹ ·j´M¥Ñ  µoªíªº¨ä¥L¤å³¹ ¦^³øµ¹ª©¥D IP ¦ì¸m ¦^¦¹­¶³Ì¤W¤è

«Ü§Öªº¡A´N¹J¨ì«O­ô³¯­zªº²Ä¤GºØª¬ªp¡A
µLªk§R°£¸ê®Æ®w¨Ï¥ÎªÌ¡A¦]¬°¦¹¨Ï¥ÎªÌ¦b¸ê®Æ®w¤¤¾Ö¦³µ²ºc´y­z¡A©Ò¥HµLªk§R°£¡C



¥H«ü¥O¬d¸ß©Î¨ì¸Ó¸ê®Æ®w¡÷¦w¥þ©Ê¡÷µ²ºc´y­z¬d¬Ý¡A³£¥i¬Ý¨ì¦¹¦Û­qªºµ²ºc´y­z¡C

«ü¥O¬d¸ß

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA




SSMSÀ˵ø¬d¬Ý



ÁöµM»¡§Ú­Ìª¾¹D³o¬O¦]¬°±ý§R°£ªº¨Ï¥ÎªÌ±b¸¹¡§¾Ö¦³¡¨¤F¦Û­qªºµ²ºc´y­z¡A¾É­P¦¹¨Ï¥ÎªÌµLªk§R°£¡A
¦ý­Y­nª½±µ§R°£¦¹¦Û­qªºµ²ºc´y­z¡A«h¤S·|¥X²{¦³ª«¥ó¦b°Ñ¦Ò¥¦¡A¦ÓµLªk§R°£µ²ºc´y­zªº¿ù»~¡F¿ù»~½X3729¡C



¦]¦¹§Ú­Ì¥²»Ý¥ý¬d¥X¦³­þ¨Çª«¥ó°Ñ¦Ò¨ì¦¹µ²ºc´y­z¡A
´_­ìª«¥óªº°Ñ¦Òµ²ºc´y­z¬°dbo«á¡A¤~¯à§R°£¦Û­qªºµ²ºc´y­z¡AµM«á§R°£¨Ï¥ÎªÌ±b¸¹¡C

¨s³º¦³­þ¨Çª«¥ó¦b°Ñ¦Ò¦¹µ²ºc´y­z¡H¥i¥Î¦p¤U«ü¥O¨Ó¬d¥X¡C

SELECT schema_name(uid) as SCHEMA_NAME, * FROM sysobjects WHERE schema_name(uid) = '¦Û­qªºµ²ºc´y­z¦WºÙ'




¬d¥X°Ñ¦Òªºª«¥ó«á¡A³z¹L¥H¤U«ü¥O§â³o¨Çª«¥óªº°Ñ¦Òµ²ºc´y­z§ï¦^dbo¡A
´N¥i¥H§R°£¦¹¦Û­qªºµ²ºc´y­z¡A³Ì«á¦A¨Ó§R°£¨Ï¥ÎªÌ¡C

ALTER SCHEMA dbo TRANSFER ¦Û­qªºµ²ºc´y­z¦WºÙ.ª«¥ó

¥H¦^´_ª«¥ó v_discount_attachments_counts ¬°¨Ò¡A»yªk¦p¤U
ALTER SCHEMA dbo TRANSFER crmctcsa.v_discount_attachments_counts




§â©Ò¦³ª«¥óªº°Ñ¦Òµ²ºc¦^´_¬°dbo¡A¦Û­qªºµ²ºc´y­z¤£¦A¦³ª«¥óÃöÁp«á¡A
´N¥i¥H¦¨¥\§R°£¦Û­qªºµ²ºc´y­z¡A¦A¶i¤@¨B§â¨Ï¥ÎªÌ±b¸¹§R°£¡C


¸U¤@§â°Ñ¦Òµ²ºc´y­z§ï¬°dbo®É¡A¥X²{°T®§15530¡Aª«¥ó¤w¦s¦bªº¿ù»~¡A¸Ó«ç»ò¿ì©O¡H



³oºØ±¡ªp¬O¦]¬°¸Óª«¥ó¤w¦³dboªºµ²ºc´y­z¡A
©Ò¥H¦A§â¦¹¦Û­qªºµ²ºc´y­zÂ൹dbo®É¡A´N·|¥X²{ª«¥ó¤w¦s¦bªº­«Âпù»~¡I



¨º¸Ó«ç»ò¿ì©O¡H

­º¥ý­n½T©wªº¬O¡A¬°¤°»ò¦³³o­Ó¦Û­qªºµ²ºc´y­z¡H
³o­Ó¦Û­qªºµ²ºc´y­z¬O§_¯u¦³¨ä¦s¦bªº¥²­n¡H¡H

¦pªG¥¦ªº¦s¦b½T¦³¨ä¥Øªº¡A
¬°¤F§R°£¨Ï¥ÎªÌ¡A¦Ó«_µM§R°£¦¹µ²ºc´y­z¹ê¬°¤£´¼¤§Á|¡I

¦pªG½T©w¦¹µ²ºc´y­z¨S¦³­«­n©Ê¡A
¨º»ò¥i¥H¦Ò¼{§â¦¹µ²ºc´y­zªºowner§ï¬°dbo¡A¨Ò¦p¥»¨Òªºµ²ºc´y­zcrmctcsa¡C
ALTER AUTHORIZATION ON SCHEMA::[crmctcsa] TO [dbo]


¦Û­qªºµ²ºc´y­z¤£¦A¸jµÛ³o­Ó­n§R°£ªº¨Ï¥ÎªÌ¤F¡A
³o­Ó¨Ï¥ÎªÌ´N¥i¥H§R°£¤F¡ã



♥¶¶¤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-10-11, 18:52 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