Could it be so easy that your Windows Firewall is blocking your ports?

I do not know about your type of errors, but wouldn't WMI from outside SQL Server be a better, and less intrusive, way of retreiving HD information?

A pure speculation would...

BTW, could it have something to do with the smiley (the wrongly interpreted format code for the forum) in the script?

Sorry, I havn't seen that problem. Have you read and followed all the header information in the script?

Maybe you also should look into updating the statistics.

Is it just the reports that takes time or are you also experiencing problems loading or removing data?

Are your dataloading in...

Remember that there are more then one SP that controls access to DTS packages. Search for all SPs with the name DTS in them and you will be surprised by...

Nice solution!

I would like to contribute too. If we only want to find IF there is a gap in the sequence we only need to verify that COUNT(*) + MIN(ID)...

Okay. For it to work you need to delete data other then the data currently locked by Access. I.e if you are doing a full delete (consider TRUNCATE instead) you...

Basically no. You can't 'open' a table without generating some kind of locks (even if you have used just a SELECT). You should investigate WHICH type of locks have been...

I would recommend the below script that I use very extensively.

It has a stand alone configuration file which is created the first time you run the script. In the script...

This seems like a violation of the first normal form. You probably shouldn't have stored your three values in one column in the first place...

Better to store them in three...

If you retrieve the query text it will contain the linebreaks and linefeeds you need for formatting your SP the way your GUI does. So if you just display the SP text...

IF you use this approach, remember the little gottcha if you try to run it in SQL Server 2000 environment; the rowsize is 8094 bytes, you can't sort and you...

Could it be an easy oversight that you have no rows where 'x' is equal or bigger then the sum(col)?

Yes. That could rise a big concern. Since all datamovement (even during defragmentation) is logged and will be kept in the transaction log, something really needs to be done either...