[20140403]查询是否产生日志

USE tempdb

DECLARE  @lsn nvarchar(100)
SELECT TOP 1 @lsn = [Current LSN]
FROM fn_dblog (NULL, NULL) ORDER BY [Current LSN] DESC;
select @lsn

SELECT * FROM AppServerProcesses.dbo.DB_PerformanceCounter ORDER BY addtime DESC


SELECT TOP 100 *
FROM fn_dblog (NULL, NULL) WHERE [Current LSN] >= @lsn 
ORDER BY [Current LSN] DESC;
GO