语源科技BlogJava-yyg1107http://www.blogjava.net/yyg1107/<center>这家伙很懒,什么都没有留下 </center>zh-cnThu, 30 Apr 2026 06:23:11 GMTThu, 30 Apr 2026 06:23:11 GMT60sql server 数据库的收缩http://www.blogjava.net/yyg1107/archive/2008/06/25/210496.htmlyoungyoungWed, 25 Jun 2008 04:43:00 GMThttp://www.blogjava.net/yyg1107/archive/2008/06/25/210496.htmlhttp://www.blogjava.net/yyg1107/comments/210496.htmlhttp://www.blogjava.net/yyg1107/archive/2008/06/25/210496.html#Feedback0http://www.blogjava.net/yyg1107/comments/commentRss/210496.htmlhttp://www.blogjava.net/yyg1107/services/trackbacks/210496.html数据库日志文件过大,按如下步骤进行

 

    需按步骤执行,不要跳跃执行

 

    1.清空日志   

       DUMP     TRANSACTION     库名     WITH     NO_LOG     

 

    2.截断事务日志：   

       BACKUP   LOG   数据库名   WITH   NO_LOG

    

    3.收缩数据库文件(如果不压缩,数据库的文件不会减小)

       数据库->右键->收缩

 

    4.如果想以后不让它日志增长得太大 

       可设定最大值(这个我没操作过,你们可以查一下帮助)

 

    顺序执行1,2,3即可

young 2008-06-25 12:43 发表评论
]]>没有工具栏、菜单的页面http://www.blogjava.net/yyg1107/archive/2007/08/28/140592.htmlyoungyoungTue, 28 Aug 2007 09:16:00 GMThttp://www.blogjava.net/yyg1107/archive/2007/08/28/140592.htmlhttp://www.blogjava.net/yyg1107/comments/140592.htmlhttp://www.blogjava.net/yyg1107/archive/2007/08/28/140592.html#Feedback0http://www.blogjava.net/yyg1107/comments/commentRss/140592.htmlhttp://www.blogjava.net/yyg1107/services/trackbacks/140592.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">

<script language='jscript'>   
if(window.name!='notool') 
{   
  //window.open(location.href,'notool','resizable=yes','toolbar=no,menubar=no,');
  window.open(location.href,'notool','toolbar=no,location=yes,status=no,menubar=no,scrollbars=no,resizable=yes,width=100,height=200');
  window.opener=null;   
  window.close();   
}   
</script>
</HEAD>

<BODY>

</BODY>
</HTML>


young 2007-08-28 17:16 发表评论
]]>第一次做成功的AXIS例子http://www.blogjava.net/yyg1107/archive/2007/08/12/136232.htmlyoungyoungSun, 12 Aug 2007 12:53:00 GMThttp://www.blogjava.net/yyg1107/archive/2007/08/12/136232.htmlhttp://www.blogjava.net/yyg1107/comments/136232.htmlhttp://www.blogjava.net/yyg1107/archive/2007/08/12/136232.html#Feedback5http://www.blogjava.net/yyg1107/comments/commentRss/136232.htmlhttp://www.blogjava.net/yyg1107/services/trackbacks/136232.html阅读全文

young 2007-08-12 20:53 发表评论
]]>命令行创建ODBC数据源http://www.blogjava.net/yyg1107/archive/2007/04/29/114530.htmlyoungyoungSun, 29 Apr 2007 03:28:00 GMThttp://www.blogjava.net/yyg1107/archive/2007/04/29/114530.htmlhttp://www.blogjava.net/yyg1107/comments/114530.htmlhttp://www.blogjava.net/yyg1107/archive/2007/04/29/114530.html#Feedback0http://www.blogjava.net/yyg1107/comments/commentRss/114530.htmlhttp://www.blogjava.net/yyg1107/services/trackbacks/114530.html命令行创建ODBC数据源


odbcconf CONFIGSYSDSN "驱动程序名" "DSN=数据源名|SERVER=服务器名|Database=数据库名"
REG Delete "HKLM\SOFTWARE\ODBC\ODBC.INI\数据源名" /v "LastUser" /f
REG ADD "HKLM\SOFTWARE\ODBC\ODBC.INI\数据源名" /v "LastUser" /t "REG_SZ" /d "sa" /f

odbcconf CONFIGSYSDSN "sql server" "DSN=heatnet|SERVER=192.168.1.199|Database=pubs"
REG Delete "HKLM\SOFTWARE\ODBC\ODBC.INI\heatnet" /v "LastUser" /f
REG ADD "HKLM\SOFTWARE\ODBC\ODBC.INI\heatnet" /v "LastUser" /t "REG_SZ" /d "sa" /f

 

 



young 2007-04-29 11:28 发表评论
]]>hibernate调用存储过程例子http://www.blogjava.net/yyg1107/archive/2007/04/23/112896.htmlyoungyoungMon, 23 Apr 2007 02:51:00 GMThttp://www.blogjava.net/yyg1107/archive/2007/04/23/112896.htmlhttp://www.blogjava.net/yyg1107/comments/112896.htmlhttp://www.blogjava.net/yyg1107/archive/2007/04/23/112896.html#Feedback0http://www.blogjava.net/yyg1107/comments/commentRss/112896.htmlhttp://www.blogjava.net/yyg1107/services/trackbacks/112896.html


http://www.blogjava.net/Files/yyg1107/hibernate调用存储过程.rar

young 2007-04-23 10:51 发表评论
]]>JS实现文本框输入提供选择框的提示功能-1http://www.blogjava.net/yyg1107/archive/2006/11/22/82754.htmlyoungyoungWed, 22 Nov 2006 06:02:00 GMThttp://www.blogjava.net/yyg1107/archive/2006/11/22/82754.htmlhttp://www.blogjava.net/yyg1107/comments/82754.htmlhttp://www.blogjava.net/yyg1107/archive/2006/11/22/82754.html#Feedback7http://www.blogjava.net/yyg1107/comments/commentRss/82754.htmlhttp://www.blogjava.net/yyg1107/services/trackbacks/82754.html阅读全文

young 2006-11-22 14:02 发表评论
]]>转：如何在JAVA中使用日期 http://www.blogjava.net/yyg1107/archive/2006/11/16/81472.htmlyoungyoungThu, 16 Nov 2006 03:11:00 GMThttp://www.blogjava.net/yyg1107/archive/2006/11/16/81472.htmlhttp://www.blogjava.net/yyg1107/comments/81472.htmlhttp://www.blogjava.net/yyg1107/archive/2006/11/16/81472.html#Feedback0http://www.blogjava.net/yyg1107/comments/commentRss/81472.htmlhttp://www.blogjava.net/yyg1107/services/trackbacks/81472.html阅读全文

young 2006-11-16 11:11 发表评论
]]>