Recent content by tdong

Hi Everyone Can anyone explain this to me please. I am setting up a Branch DC for our domain(all server 2003 standard R2) via VPN site to site connection. DNS everything is correct but I just couldn't join the Domain or do dc promote. However when I take the Branch DC connect directly to...

assuming the password is correct I cut and paste and got different password

the thing is if I put both gDevServer and gProdServer on the same server then it work but it doesn't work if I put it on a different server. example Server1 and Server2 gDevServer = gProdServer = "Server1" then it work gDevServer = "Server1" gProdServer = "Server2" doesn't allow me to log in...

Thanks I definitely think there is something wrong with the onboard Raid, I try to reseat everything wait for 1 hour or more at the Raid setting still won't boot. I reset the jumper and set to SCSI only mode it boot up everything works fine. I guess time to buy a new PCIX raid controller card...

Hi the problem is if Raid won't boot nothing else will boot including Floppy and CD, it just hang at the raid load.

Thanks for reply After the Raid 5 fail I only have two drive left therefore I decide to erase everything and setup Raid 1 for the mirror of the two drive only (OS installation). Now it just hang whenever I try to setup Raid in the bios. It won't boot the raid setting. I stop at press control...

Hi My raid 5 was working fine until one of the drive fail i try to rebuild raid but it just won't let me boot to the raid ultilities. It will just stop at Press control M or H it just hanging there. I try to reseat the memory the raid key the battery doesn't work. I set it to SCSI only in...

The thing is I don't know which rows need to update. But i can check for it since the excel will be updated daily by bloomberg. Everyday some rows mayhave new value some doesn't change at all The problem is if I insert 1000 row and 8 column everyday it would be over kill. For number 2...

What is the best way to insert excel data to database with 1000 rows and 8 column each day. Need to keep history but not all the value in there changes everyday 1)One way is to insert all of them everyday too much data 2)Only insert the changes for each row and columns <--need some idea on...

I need the rating value not name I change it. The only problem is that it select max(ratingval) for the last line in insert I change value to 1 it still return 6 since 6 is max. I need it to return rating value for max(date) DECLARE @rating TABLE (compid Int, ratingname char(2), ratingval...

Thanks for your help it works great.

Thanks I can't get it to run in querry analyzer yet there is an error in the where statement any idea thanks ?

I think I post to the wrong forum I don't use VFP thanks

Hi Thanks I will try that. I am using Sql 2000, VB6, VB.net , Crystal Report for reporting

I have two tables Table 1 ID CompanyName 1 A 2 B Table 2 <--this table only record the change in RatingName Value ID RatingName Value TimeStamp 1 T1 5 10/11/2006 1 T2 5 10/11/2006 2 T1 5 10/11/2006 2 T2 5 10/11/2006 'default value above and...