Search results for query: *

Thanks for the replies everyone. Both examples worked perfectly ... and thanks for the link so I can learn and understand the functionality. Dale

Hi, I'm having difficulty selecting and dynamically updating rows in a single table, based upon the records having more than one shipto_id in any given order. If I have data such as: ORDER_NO SHIPTO_ID 1 20 1 21 1 21 2...

I think we've discovered the issue. Previously, we had turned off the antivirus monitoring software, but the issues continued. We actually uninstalled the entire antivirus client (Sun Systems, Vipre) last week and the freezing issue has not been a problem since that point. Thought I would...

Yes, it is the OS volume that's getting hammered. That volume has the stm and log files. The non-OS drive has the edb files. The OS drive has about 18 GB free, and is fairly fragmented. I can run defrag again on the OS drive. It is the entire server, not just Exchange, that freezes. The...

Well, as soon as I say we're going through a good period, the server freezes. We had the performance monitoring tool up and monitoring when it froze. You are exactly right, just prior to the freeze the read and write queue jumps significantly. (It did have many similar spikes prior to that...

ShackDaddy, FYI, haven't forgot about this thread. Our Exchange server happens to be in a good period right now. As soon as it freezes again, I'll post back here. Thanks again for your help. Dale

No, we have not done any performance monitoring. Do you have suggestions on the tool to do the monitoring? I found one for Windows Server 2003 from Microsoft here: http://www.microsoft.com/en-us/download/details.aspx?id=15506 If this will work we'll d/l and install it. If there's another...

Hi ShackDaddy, Thanks for the reply. Storage on server are two sets of RAID 1 SATA drives. We did run a chkdsk on both and told it to repair the errors. There are no system log errors from the source "Disk". The edb files are on one RAID set, the stm files on the other. The only errors...

ntinlin, Thanks for the reply. Freezing encompasses: 1. Users are disconnected from their mailboxes 2. Cannot use the GUI on the Exchange Server (cannot get it to ever go off of screen saver ... have tried turning screen saver off also) 3. I don't believe the CPU is at 100% ... because if...

We have an Exchange 2003 Server that freezes up periodically. It can freeze up 6 times a day, or once in two weeks. It's very sporadic. We have tried running isinteg on the database, and also ran defrag on it, but it still freezes. If we dismount the information stores, the server never...

CoSpringsGuy, Perfect! Thanks!

CoSpringsGuy, Thank you for the reply and teaching me about the previous command. Your assumption was correct that the negative entry will ALWAYS be after the entry it is supposed to be correcting. At this point, it is displaying the problem reversals. And actually, that's much better then I...

Hi, I have a single table report that is sorted by PO# then Item#. The data looks something like: Line ---PO ---- Item ----- Qty ----- Cost ---- Ext Cost 1 ------ 1 ------ A -------- 2 ------- 3.20 ------- 6.40 2 ------ 1 ------ A ------- -2 ------- 3.20 ------ -6.40 3 ------ 1 ------ A...

Thanks for the reply ShackDaddy! I went into OWA, and the missing emails were not included (for me). I took a look at the 301 messages in the Application Log, all look well. Interesting thing happened though. I let the staff know that they may be missing emails during the specific dates I...

Hi, We had a corrupted Exchange 2003 edb file. We had a backup of the edb and stm files from several days ago. Those backup files are in place and can be mounted and viewed. We have the log files from the days that are missing, but we cannot get the eseutil recovery process to add the emails...

Hi, We have a Sonicwall NSA 2400 firewall. We also utilize Viewpoint. When I look at Viewpoint, I see external IP addresses as the "Users" inside the "Top Users of Mail" screen (along with mostly internal IPs). These external IPs usually have many more connections recorded than the internal...

Thanks for the corrections! It got past the error I was getting. I first received an error for an unknown object on the SVR-REPSONSE. I ended up taking off "SVR-RESPONSE" off the name of the table/field references because I am writing the command "from" SVR-RESPONSE as the starting point (see...

Thanks hilfy and kray. I decided to try the CAST function first. Here is my syntax: select "SVR-MAIN-TLS007"."pvtApDetHist"."PONum", "SVR-RESPONSE"."POHEAD"."PO_NUMBER", CAST(PO As Integer) "PONum" From "SVR-MAIN-TLS007"."pvtApDetHist" from "SVR-RESPONSE"."POHEAD" inner join...

Hi, I have two separate databases that I need to link together based upon a common field (PO #) which is a text field in one database and a numeric field in another. I found a Tek Tips thread that appears to address the issue ( http://www.tek-tips.com/viewthread.cfm?qid=1614914 ). I attempted...

Thanks! It works like a champ. Dale