Ok. So if I am understanding correctly is that a process is likely holding a Lock on some resources that alot of people access. SO I could probably use activity...

Thanks for the tips guys. I am looking at those tools now.

ANother question. Can someone explain the difference between a Lock and a Block? Are you guys suggesting it is...

Works great. Thankyou very much!

Thanks for the awesome help. Works great. After I saw what happend in the query designer after I dropped in your sql statement I felt a little foolish asking the...

So do I place that right into the filter critera box in the query designer?

The table name is "TheValues" , the PK field is [Desc] and the value in the PK field needs to "ComPeriod". Then it is the value in the "TheData" field...

Nothing complicated. I owuld like to be able to do the equivilant of dsum and dcount in access. dsum accepts a field name, table name and criteria and will return...

The ID is char(12)... The two examples you gave are what you could expect in this database.

I tried that and it doesent work either

Thanks once again for the breakdown Carl. Would the windows defrag untility work ok or should we look at another product?

OK. Correct me if I am wrong. I want to defragment but not shrink the database?

Hi Carl. Thanks for the excelent reply. I appreciate you breaking it down for me like that. I can see that I need to spend some time in study to...

Thank you for all the great replies. I ran dbcc showcontig on our largest database, it took about 5 minutes to run. I am not sure I understand what the...

Where would I begin to learn about this process?

The server itself does a complete backup to a single file at noon everyday and there is a complete backup of all databases by symantec backup exec every midnight. I...