SQLTeam.com | Weblogs | Forums

The "fn_dblog" deleted when I restart the Server

I am running script:

select *
from fn_dblog(NULL, NULL)

to check on the transaction log. But it seems, whenever I restart the Server / Service, the "Results" will be cleared.

Any way to prevent this from happening?

I don't have BOL in front of me but doesn't that function allow you to specify which log file to use? The default (NULL) would be the current one but, since the service just restarted, the log would be empty.