Recent content by mairving

ESquared, Thanks. Yep I see the extra ). Okay here are some examples if that will clarify things. Table - Inventory (itemid 1) itemid = 1 locationid = 1 qty = 2 itemid = 1 locationid = 2 qty = 1 Table - Inventory (itemid 2) itemid = 2 locationid = 1 qty = 5 itemid = 2 locationid = 2 qty = 3...

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...

Thanks that did it. The part that I left off was creating the gpa var.

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...

Are you sure that winbind is started? This seems to be the message that I get when I run wbinfo when winbind is not started. Also, you can leave the winbind separator out of smb.conf, it will use the default (/) one instead. Oddly enough I am dealing with a similar issue but it can enumerate...

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...

The Unix agent can be downloaded from Veritas if it isn't on the CD. It is a little funky to install but works pretty well. I wouldn't advise using Samba to backup since that would be very slow. Here is a link to install the agent from Veritas; http://seer.support.veritas.com/docs/240654.htm

Yeah, I was finally able to get it resolved. I went into Server Manager on the NT box and was able to remove the computer from the domain. I also had to add a lmhosts setting to the NT box to tell it who the PDC was. All is fine now. Thanks.

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...

That is the ticket. You already have AD running which would make it even easier. You would basically move the mailboxes change the incoming mail connection to point to the new server, test the server for security, alter your backup scheme and go. Microsoft's document that has been previously...

You don't have to keep the same server name. As a matter of a fact, that could possibly be a nightmare. When you move mailboxes off of the 5.5 server over to the 2K one, it will change the server for you so you don't have to go to everyone's machine and manually change the name.

I have looked at that one before but it looks like it is an issue with Windows Server 2003 and Exchange 2000. It didn't seem applicable in this case. Thanks.