Charles Kincaid (11/10/2009)
Thanks James. I'm having a great deal of trouble seeing your script. Must be this silly IE 8.
That sure did a horrible formatting job...
here is the script again...without the formatting by SSC.
--START SCRIPT
SELECT * FROM #LogInfo
WHERE ([CURRENT LSN]) >
(
SELECT TOP (1) [Current LSN]
FROM #LogInfo
WHERE [Checkpoint Begin] IS NOT NULL
ORDER BY [Checkpoint Begin] DESC
)
--END SCRIPT
Thanks,
James
~ Without obstacles, you cannot progress ~
http://sqln.blogspot.com/