¼±£¬sqlserver½ø²»È¥ÁË£¿[
ûÁ¬½ÓÍøÏߣ¬ÎÒÔÚ±¾»úÉϰ²×°µÄsqlserver2008¾Í½ø²»È¥ÁË¡£Ôõô½â¾öÄØ£¿
±¾µØ²»ÄܵǼÂð£¿.......
ÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄÊǵÄ
Óà windowsÉí·ÝÒ²²»ÄܵǼÂð£¿
ÄãÁ¬½ÓµÄÊý¾Ý¿âÊÇÕą̂µçÄÔ
»¹ÊÇÆäËüµçÄÔ£¿£¿
Ìáʾʲô£¿ÊÇûÆô¶¯»¹ÊÇÎÞ·¨Á¬½ÓÉÏ£¿
·þÎñÊÇ·ñ¿ªÆô£¿
¶Ë¿ÚÊÇ·ñ´ò¿ª£¿
Ó¦¸ÃÊǰ²×°ÎÊÌâ°É£¡£¡£¡
ûÓдíÎóÌáʾÂð£¿
ÔÚ¡°ÅäÖùÜÀíÆ÷¡±ÆôÓÃÁË¡°¹²ÏíÄڴ桱ÐÒéÁËÂð£¿
¹À¼ÆÊǹ²ÏíÄÚ´æÃ»ÓÐÆôÓ㬿ÉÒÔ´ò¿ªSQL serverÅäÖùÜÀíÆ÷²é¿´Ò»Ï¡£
°²×°°æ±¾²»¶Ô¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÎÒÔÚ±¾»úÉϰ²×°µÄsqlserver2008¾Í½ø²»È¥ÁË¡£Ôõô½â¾öÄØ£¿
Ìáʾʲôѽ,
¼ì²éһϠSQL Server µÄ´íÎóÈÕÖ¾£¨Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG£©ÖÐÓÐʲô´íÎóÏûÏ¢¡£
http://yk216.blog.51cto.com/252445/119131
ÏȲο¼ÉÏÃæµÄ,
²éÒ»ÏÂϵͳÈÕÖ¾,¿´É¶´íÎóÀ´×Å
SQL code:
»»¸ö°²×°ÅÌ£¬ÖØÐ°²×°Ò»ÏÂ...
ͨ¹ý»¹Ôϵͳ½â¾öÁË£¬µ±È»Ò»Ð©Êý¾Ý¿âÒ²¶ªÊ§ÁË¡£
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÏÖÔÚÎҵı¾»úÊÇÓõÄsqlserver2000°æ±¾µÄ(¿ÉÒÔÕý³£µÄÁ¬½Ó)¡£Êý¾ÝÁ¬½ÓÈçÏ£ºproxool.xml
XML code:
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÎÒн¨SqlServer×¢²á-¡·ÏÂÒ»²½-¡·Ñ¡ÔñÒ»¸öSql Server ÀïÃæ ÏÂÃæ×ó±ßÄǸöÁбí¿ò¿ÉÓ÷þÎñÆ÷ÀïÃæÊ²Ã´Ò²Ã»ÓÐ ÎҲŽӴ¥Õâ¸ö ´ËʱºÍÊéÉÏдµÄÍêÈ«²»Í¬ Òò´ËÎÒËæ±ãÌî¸öÃû×ÖÉÏÈ¥ È»ºóÏÂÒ»²½ ÕâÑù×îºóµÄ½á¹ûÊÇSqlServer² ......
лл
SQL code:
exec sp_lock --¿´ objId
È»ºóÓÃ
select object_name(ObjID)
ÒýÓÃ
SQL codeexec sp_lock--¿´ objId
È»ºóÓÃselectobject_name(ObjID)
ÎÒÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ,Ôõô²»ÄÜÖ´ÐÐÄØ? ......