I am trying to update a numeric field in a table. It is a quantity on hand(Decimal) column. Basically I would have:
An indexed field - itemid
A location_id
The quantity field.
This query works:
UPDATE tablename
set [quantity]
= (SELECT [quantity] as qoh from inv_loc where [itemid]= 'value' and...
I am trying to do a class ranking. It is pretty easy to do in Excel using the rank function. When I do it in Crystal here is what I have:
Name GPA Rank
Student 1 4.00 1
Student 2 4.00 1
Student 3 4.00 1
Student 4 3.89...
For some reason, my outgoing timestamp is off by -5 hours. This makes the sent time incorrect in outgoing messages. This is also affecting my log files. The server time is correct and set to sync up to a local timeserver in the domain. The times and time zones on all machines are correct but the...
Okay, here is the scenario. I have a Samba Server 3.0.4 running FreeBSD in a W2K AD. It is also running winbind so that I won't have to add local users/groups the the BSD box. It works fine. It's primary purpose is to be a Fileserver. There is a directory called Users that holds all of the User...
I have upgraded all of my domain controllers to W2K except for my last remaining NT BDC. It had Exchange 5.5 on it but Exchange 2000 was added to another server and Exchange 5.5 has been removed. The machine is currently shutdown and will be robbed for parts. How can I remove it from the the...
I have Backup Exec 8.5 installed and working. It has several agents that I got when I got the original software. One of the agents is the MS Exchange Agent. This agent has worked fine on Exchange 5.5. I recently upgraded my Exchange server to 2000 and the agent wouldn't not work (couldn't see...
Okay here is the scenario:
One NT 4.0 Server running Exchange 5.5
One W2K Server running Exchange 2000.
One W2K DC.
I was in what I thought was the final stages of moving mailboxes off of the old 5.5 server to the new 2000 server. In the process there were 2 mailboxes that couldn't be moved...
I am getting this error:
Source: MSADC
Category: Service Controller
Event ID: 8108
every 5 minutes on a new Exchange 2000 Server. The network is setup like so:
NT 4.0 BDC Server running Exchange 5.5
W2K DC Server Global Server
W2K Exchange Server, not a DC but a member server.
I have 2 ADC...
Okay I have setup a Windows 2000 AD runnning ISA server. It works fine for a couple of hours then the only way to fix it (get the proxy service running) is to reboot the server. The setup is like this:
Netopia DSL Modem/Router - 192.168.1.254
W2K Server External Port - 192.168.1.x
W2K Server...
Okay here is the scenario. I am in the process of upgrading my domain from a NT one to a 2K AD one. Here is the current setup:
--PDC running NT, Exchange 5.5 and several other apps.
--3 Linux Servers running Samba, one is a fileserver, one is a proxy server and the other is a web development...
I am just about to get started in upgrading an Window NT Server 4.0 with Exchange 5.5 to Windows 2000 with Exchange 2000. It is not an in-place upgrade but a new machine. The Exchange 5.5 server has some problems with the database. I have had to repair the database once because of errors...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.