I use this to find page splits:

USE <DB>

select AllocUnitName, count([AllocUnitName]) [Splits]

from ::fn_dblog(null, null)

where Operation = N'LOP_DELETE_SPLIT' and parsename(AllocUnitName,3) <> 'sys'

group by AllocUnitName

I can't take credit,

ecpasos,

You are correct to a point. This example does not show how to do it remotely.

I was able to produce a scenario here with the following:

I changed...

The number of connections does not seem to be an issue. Though I have 20+ linked servers, I only have 2-3 concurrent connections at any given time to all...

don1941,

Thanks for the quick reply. I have validated all params are the same. Timeout is set to indefinte(0) I'm on SQL2k/sp2.

Any other idea's?

I'm going to talk...

I have been doing database work for 10 years and SQL Server since the beginning and hold no certifications. I’m married with 3 kids, a full-time job, and have my...

Brian,

I agree with most of what you stated in your article. I believe the Production DBA has been dead since SQL 2000 came out. We just haven’t smelled the body...

One last thing. L0phtCrack as far as I know can't decrypt SQL2000. I did want to miss lead you in thinking that there is something out there that you can...

I agree with Steve. Any encrption can be broke given time, hash encrption included. Look at L0phtCrack. It is able to do hash decryption against NT passwords and if memory...

Actually there is a app that will decrypt sql2000 goto http://www.geocities.com/d0mn4r/

Rob