08 2010 档案

【转贴收藏】sql2000 undoocumented DBCC Commands
摘要：Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands Alexander Chigrik chigrik@mssqlcity.comIntroduction In this article, I want to tell you about some useful undocumented DBCC commands, and... 阅读全文
posted @ 2010-08-19 09:52 不能飚车 阅读(474) 评论(1) 推荐(0)
【转贴收藏】SQL常用语句，含查看数据库日志
摘要：--//清空日志checkpoint--//查看数据库日志select * from ::fn_dblog(null,null)select * from ::fn_dblog(null,null) where [current lsn]>='000001ae:00000074:0001' and [current lsn]<= '000001ae:00000085:0005'--//... 阅读全文
posted @ 2010-08-19 09:49 不能飚车 阅读(1776) 评论(0) 推荐(0)