Wed, 01 Jun 2011 04:26:00 GMTCSDN博客聚合服务http://blog.csdn.net/blogrss.aspx?username=tedyhttp://blog.csdn.net/tedy/archive/2011/06/01/6458957.aspx<br />日志：<br />C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log<br /><br />2011-06-01 12:16:35.44 Server      Error: 17051, Severity: 16, State: 1.<br />2011-06-01 12:16:35.44 Server      SQL Server evaluation period has expired.<br /><br />试用期过期！<img src="http://www1.feedsky.com/t1/517976370/tedy/csdn.net/s.gif?r=http://blog.csdn.net/tedy/archive/2011/06/01/6458957.aspx" border="0" height="0" width="0" style="position:absolute" />Wed, 01 Jun 2011 12:26:00 +0800葛龙http://blog.csdn.net/tedy/archive/2011/06/01/6458957.aspx葛龙http://blog.csdn.net/tedy/archive/2011/06/01/6458957.aspxhttp://blog.csdn.net/tedy/feed.aspxcsdn.net/tedy/~1195767/517976370/1195745http://blog.csdn.net/tedy/archive/2011/03/24/6273322.aspx<br />1.插入中文时候乱码：在中文内容前加 N<br /><br />insert into table(col1,col2) values(N'中文',N'中文'）<br /><br />insert into table1(col1,col2) select N''+col1+'',N''+col2+''  from table2<br /><br />2.查询中文数据时：在中文内容前加 N<br /><br />select * from table where col1=N'中文'<img src="http://www1.feedsky.com/t1/517976372/tedy/csdn.net/s.gif?r=http://blog.csdn.net/tedy/archive/2011/03/24/6273322.aspx" border="0" height="0" width="0" style="position:absolute" />Thu, 24 Mar 2011 10:24:00 +0800葛龙http://blog.csdn.net/tedy/archive/2011/03/24/6273322.aspx葛龙http://blog.csdn.net/tedy/archive/2011/03/24/6273322.aspxhttp://blog.csdn.net/tedy/feed.aspxcsdn.net/tedy/~1195767/517976372/1195745http://blog.csdn.net/tedy/archive/2011/03/09/6233311.aspx1. 打开 Report Manger 页面<br />2。选择你要删除的报表，进入属性（Properties）， 选择删除即可。<br /><br />report manger的URL， 可以从报表服务器的 Start-->All Programs--> Microsoft SQL Server 2008/5-->Configuration Tools-->Reporting Service Configuration Manager-->Report Manager URL 进入。<img src="http://www1.feedsky.com/t1/517976373/tedy/csdn.net/s.gif?r=http://blog.csdn.net/tedy/archive/2011/03/09/6233311.aspx" border="0" height="0" width="0" style="position:absolute" />Wed, 09 Mar 2011 09:50:00 +0800葛龙http://blog.csdn.net/tedy/archive/2011/03/09/6233311.aspx葛龙http://blog.csdn.net/tedy/archive/2011/03/09/6233311.aspxhttp://blog.csdn.net/tedy/feed.aspxcsdn.net/tedy/~1195767/517976373/1195745http://blog.csdn.net/tedy/archive/2011/02/23/6201984.aspx<br />把字体Tahoma换成細明體<img src="http://www1.feedsky.com/t1/517976374/tedy/csdn.net/s.gif?r=http://blog.csdn.net/tedy/archive/2011/02/23/6201984.aspx" border="0" height="0" width="0" style="position:absolute" />Wed, 23 Feb 2011 11:34:00 +0800葛龙http://blog.csdn.net/tedy/archive/2011/02/23/6201984.aspx葛龙http://blog.csdn.net/tedy/archive/2011/02/23/6201984.aspxhttp://blog.csdn.net/tedy/feed.aspxcsdn.net/tedy/~1195767/517976374/1195745http://blog.csdn.net/tedy/archive/2011/02/11/6178621.aspx<br />配置文件问题，删除app.config，或者重新配置。<img src="http://www1.feedsky.com/t1/517976375/tedy/csdn.net/s.gif?r=http://blog.csdn.net/tedy/archive/2011/02/11/6178621.aspx" border="0" height="0" width="0" style="position:absolute" />Fri, 11 Feb 2011 11:58:00 +0800葛龙http://blog.csdn.net/tedy/archive/2011/02/11/6178621.aspx葛龙http://blog.csdn.net/tedy/archive/2011/02/11/6178621.aspxhttp://blog.csdn.net/tedy/feed.aspxcsdn.net/tedy/~1195767/517976375/1195745http://blog.csdn.net/tedy/archive/2011/02/08/6174345.aspx<br />一、<br />下载VFPOLEDBSetup.mis<br /><br />二、<br />连接字符串：Provider=vfpoledb;Data Source=dbf文件路径;Collating Sequence=machine;<br /><br />三、<br />1.获取有效数据（不带删除标记）<br />select  * from **.dbf<br /><br />2.获取所有数据（包括带删除标记和有效数据）<br /><br />先执行语句：SET DELETED OFF<br />再执行：select  * from **.dbf<br /><br />3.获取删除数据（带删除标记的）<br /><br />先执行语句：SET DELETED OFF  ----(不知道为什么，一定先执行这句，再下面那句那句，才有删除数据)<br />再执行：select  * from **.dbf where Deleted()<img src="http://www1.feedsky.com/t1/517976376/tedy/csdn.net/s.gif?r=http://blog.csdn.net/tedy/archive/2011/02/08/6174345.aspx" border="0" height="0" width="0" style="position:absolute" />Tue, 08 Feb 2011 10:13:00 +0800葛龙http://blog.csdn.net/tedy/archive/2011/02/08/6174345.aspx葛龙http://blog.csdn.net/tedy/archive/2011/02/08/6174345.aspxhttp://blog.csdn.net/tedy/feed.aspxcsdn.net/tedy/~1195767/517976376/1195745http://blog.csdn.net/tedy/archive/2011/01/24/6160977.aspx<br />1.SQL Server和SQL Server Agent——》属性——》"Log On"——》"Local System Account"<img src="http://www1.feedsky.com/t1/517976377/tedy/csdn.net/s.gif?r=http://blog.csdn.net/tedy/archive/2011/01/24/6160977.aspx" border="0" height="0" width="0" style="position:absolute" />Mon, 24 Jan 2011 12:16:00 +0800葛龙http://blog.csdn.net/tedy/archive/2011/01/24/6160977.aspx葛龙http://blog.csdn.net/tedy/archive/2011/01/24/6160977.aspxhttp://blog.csdn.net/tedy/feed.aspxcsdn.net/tedy/~1195767/517976377/1195745http://blog.csdn.net/tedy/archive/2011/01/24/6160737.aspx"Object Explorer"里面选中某个服务器——》右键——》"Facets"——》选择"Server Configuration"——》"AgentXPsEnabled"改为"True"<img src="http://www1.feedsky.com/t1/517976378/tedy/csdn.net/s.gif?r=http://blog.csdn.net/tedy/archive/2011/01/24/6160737.aspx" border="0" height="0" width="0" style="position:absolute" />Mon, 24 Jan 2011 10:47:00 +0800葛龙http://blog.csdn.net/tedy/archive/2011/01/24/6160737.aspx葛龙http://blog.csdn.net/tedy/archive/2011/01/24/6160737.aspxhttp://blog.csdn.net/tedy/feed.aspxcsdn.net/tedy/~1195767/517976378/1195745http://blog.csdn.net/tedy/archive/2010/12/06/6058394.aspx一、     SQL2008 中 SSIS， Excel 导入目标数据库，报如图错误：说明在“Data Conversion”中，转换列的“code page”设置不正确，文中“（950 and 1252）”中的“1252”是目标数据库的code page ,只要把列中的code page ，选择和目标数据的一致，就好了。<img src="http://www1.feedsky.com/t1/517976379/tedy/csdn.net/s.gif?r=http://blog.csdn.net/tedy/archive/2010/12/06/6058394.aspx" border="0" height="0" width="0" style="position:absolute" />Mon, 06 Dec 2010 15:16:00 +0800葛龙http://blog.csdn.net/tedy/archive/2010/12/06/6058394.aspx葛龙http://blog.csdn.net/tedy/archive/2010/12/06/6058394.aspxhttp://blog.csdn.net/tedy/feed.aspxcsdn.net/tedy/~1195767/517976379/1195745http://blog.csdn.net/tedy/archive/2010/09/10/5875882.aspx<br /> 1. flashback table table_test to timestamp to_timestamp('20091103000000','yyyymmddhh24miss');<br /> 2.如果报错 ORA-08189: cannot flashback the table because row movement is not enabled<br /> 3.alter table table_test enable row movement;<br /> 4.OK<img src="http://www1.feedsky.com/t1/517976386/tedy/csdn.net/s.gif?r=http://blog.csdn.net/tedy/archive/2010/09/10/5875882.aspx" border="0" height="0" width="0" style="position:absolute" />Fri, 10 Sep 2010 15:19:00 +0800葛龙http://blog.csdn.net/tedy/archive/2010/09/10/5875882.aspx葛龙http://blog.csdn.net/tedy/archive/2010/09/10/5875882.aspxhttp://blog.csdn.net/tedy/feed.aspxcsdn.net/tedy/~1195767/517976386/1195745