Search results for query: *

I might start looking for a data problem in one of the associated tables involved in the process. Your support provider should be able to advise you of which tables to look at. Perhaps run the File Validation utility on those. John

AKPolarBear, You can create a SQL script file and run it in Query Analyzer to track down a lock placed on a specific table. Try this for your script. use msllockdb go select sessionid, tablename, rowid from maclocks exec sp_who

HKNinja: It's not the MDF file that is the issue. That stays relatively static, it's your transaction log file thats is always growing and shrinking. For example our MDF file writes to our RAID 5(72GB) array where as our tranaction log LDF file is stored on the RAID 1(36GB) array. The LDF file...

We have been using a Dell 2650 for about 3 1/2 years, so far no problems. Dual 2.4 Ghz Xeon 2GB RAM RAID 1(36GB)/RAID 5(72GB) 30 Users Version 7.6.300B This is a dedicated SQL server, Progression is on a different box. My only regret was not making the disk array larger. Our live company DB is...

Donna, I'm really glad you posted your message as I am/was planning on upgrading from 7.6.200 to 7.6.300b this weekend. Did you encounter this problem when you installed the 7.6.300 upgrade or when you installed the service pack "B"? Also Don we are on SQL, are you aware is this an issue in the...

You could use this "put all your eggs in one basket" approach for a site with a small number of users. However if you ever had problems your whole network could be affected. I'm a strong proponent of using dedicated hardware for specific tasks or services. We operate a site similar to...