| http://www.w3.org/ns/prov#value | - The following is an example that works in SQL Server 2000, 2005, and 2008: SET NOCOUNT OFF DECLARE @sql VARCHAR(4000) DECLARE @lognumber INT DECLARE @logcount INT SET @lognumber = 0 -- create temp tables to hold the information CREATE TABLE #dbcc (rowid INT IDENTITY PRIMARY KEY, entrytime DATETIME, source VARCHAR(50), logentry VARCHAR(4000)) CREATE INDEX [dbcc_logentry] ON dbo.[#dbcc](logentry) WI
|
