It's been a long time ago that I updated from SQL 6.5 to 2000, but it seems like there is a DTS task to move log ins.

Have you tried...

Congratulations on achieving this historic milestone!

I foresee more and better for you guys.

Keep up the wonderful work!:hehe:

No you don't have to have another dataset.

right click on your list of fields over on the left hand side where it says report datasets, and click the add. You'll...

I've done this, but it still gives me a blank line.

Any other suggestions?

Thanks,

Margaret

Why do you reindex? Is there any advantage to doing it on a regular basis? How often would you recommend reindexing (if at all)?

I have some really huge tables (millions of...

So, if it says that my log file is using 1.06 % of the space should I truncate it?

We do reindex the larger tables as part of the nightly jobs.

dbname...

Steve:

Thank you for your explanation and information. I did the DBCC OPENTRAN as suggested, but I'll be darned if I understand what it says

Transaction...