Add 2 more things I've learned... DBCC UPDATEUSAGE and about Books Online (mentioned in other replies/topics), this time I search for it, found it, found the article and read it.

Thanks...

Wow. 🙂

I'm sitting here smiling - that was fast, easy, and exactly what I needed.

I'm slowly learning SQL Admin tasks - it's nice that I don't...

I'm (slowly) figuring out how to use Profiler and getting close - other higher priority projects are demanding my time.

Thanks everyone for your help!

OK. Thanks.

I ran profiler again this morning, a few users happened to be active. But, I did see my transactions mixed in with the others. Then I got pulled away....

Ah. The picture is coming into focus for me. (Let's see if my picture is correct - 🙂 )

Some ERPs I've worked with are installed client side. That's mostly where...

There's something I'm not understanding.

I see there are two hits on the HD instead of one. HD access is a bottleneck. (Here comes the part where I'm probably missing something)....

OK. Thanks for that part.

What's the objective? Doesn't the statement that returns actual rows accomplish the same thing, plus the data? i.e. Why would the program want to get the...

Thanks for the reply.

I looked at Stored Procedures in SQL Server Enterprise wondering if that would be the same as what is returned in your first statement. The first thing...