Search results for query: *

Hi all, we using MSSQL2000 after applay SP2(english) I dont know how to change national language support (problem with weeks:-> US weeks not start in Monday). Anybody know how to solve this problem? thanks Frenkie

Hi vb8304, I not have any luck, but I snifing for any help. Was good document wrote about it for 5.5, but nothing for 2000. Also Microsoft say, you may rebuild your database when you have all log files, which I have, but they not say how. Maybe I found one possible way, but I don't know...

I think your design is OK. Usualy is good using NOT data but other column as PK, because all other data could be changed. Also index based on small data like int, or small int is better then using bigger. Processor faster compare 4 bytes against 4 bytes as comparing long strings.Also I read...

I setting this column's value to null

Thaks for tips tlbroadbent, foxdev. Here is more info about this problem. I updating one field in whole table with NULL value. I have also index for that field, but sometime this operation do it after 10min, 5 min, sometime for 20 min. I understand that this operation is depended on many...

Hi all, I have two processor system with instaled SQL server. Sometimes this processors works on 100% somethimes on 1% on the same task. Why? Have anybody good advise how to powering this system? Also I have DB Tabe with 1.6 milion records. Is normal that Update takes about 20min? thanks, Frenkie

Hi all, my server (PDC with Ex2000) before few days crash.(file system was corupted) Was no any chance put it together. So I reinstall it. I have this crashed system on one disk and priv.edb, pub.edb on other disk. Question is how to get data from priv.edb and pub.edb and insert it to new...