Search results for query: *

Thank you gmmastros, Here is the correct code for what I am doing. UPDATE tblLeads_Info SET PWGCity = UPDATE_AddToPWGCity1.PWGCity FROM tblLeads_Info, UPDATE_AddToPWGCity1 WHERE (tblLeads_Info.NameID = UPDATE_AddToPWGCity1.NameID)

I am trying to pass the value 212 from the 2 column table UPDATE_AddToPWGCity1 to the tblLeads table with column PWGCity.

DECLARE @PWGCitya int UPDATE tblLeads_Info SET tblLeads_Info.PWGCity = @PWGCitya SELECT @PWGCitya = UPDATE_AddToPWGCity1.PWGCity FROM tblLeads_Info INNER JOIN UPDATE_AddToPWGCity1 ON tblLeads_Info.NameID = 645526 AND UPDATE_AddToPWGCity1.NameID = 645526

Iwcomputing, First I would like to thank you for all your help. Here are the C and D drive stats. Volume (C:) Volume size = 10.17 GB Cluster size = 4 KB Used space = 5.99 GB Free space...

Iwcomputing, I haven't ran defrag so I do not have that information. I am still waiting to get a response from the person who takes care of this. I am concerned based on the info they provided. I am looking for a general concensus on whether or not defragging isn't that important on a web server.

Iwcomputing, Our Windows 2003 server has a C drive with 10.17 GB and free space of 4.2 GB. D drive with 91.53 GB and free space of 18.34 GB.

I used analyze in the disk defragmenter for our windows 2003 server. It shows that our server is heavily fragmented. It is a Windows 2003 Standard Server, and it runs our company website. Do we need to free up some disk space on the server to make defragging work properly? It takes forever for a...