quote:

---

There is also a script here that can help

http://qa.sqlservercentral.com/scripts/contributions/26.asp

Steve,

I use SQL Server 2000, and that code doesn't work. For example, dbcc loginfo returns CreateLSN, which is a large integer such as 115000000048700025, not a datetime value. I changed the type to varchar(25). Executing it, the same values are always returned regardless of the active database.

Steve Jones

sjones@sqlservercentral.com

http://qa.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/

http://www.dkranch.net

---