Search results for query: *

We have an Exchange 2000 server running. I recently set up a Win2003 box with Exchange 2003, the goal to move everything from the old Exchange server to the new one. I have the new Exchange server running and everything seemed to work. I created a test mailbox on the new server and was able...

Our Exchange Server is part of Small Business Server 2000. This server is getting bogged down so we want to get another server and install Exchange 2003 on it and stop using the Exchange part of SBS on our old server. Is there any limitation of SBS that would prevent this? I searched but...

Three tables: items_on_programs, execsales, catalog Below is the current query I have which uses items_on_programs and execsales. The results displays a list of SKUs and shows how manu were ordered (SUM(e.qty_orderd). I need to not just display the SKU, but also the product name and UPC for...

The below query is not working. I have a table of order contents. Each record in the table is a line item. I need to add up the quantities for each order and display each order whose total quantity is >= 100. Any suggestions? SELECT itm_ord_num, Sum( qty ) AS Qty1, oper_id3, vfy_date FROM...

I have a MySQL table which has a field called "release_date". This field is a date field and the format of the date used is "CCYY-MM-DD". I need to be able to say show me all titles with release_date > today. I first tried using time() to get the current date but that doesn't work in the...

I have two tables. One lists SKUs that are on "programs". The other table has sales info for all SKUs we sell, not totally up (each record is a line item on an order, so the SKU repeats many times). I have a page which displays all the info for the particular program (stored in a table...

I'm trying to determine if there is something going on our network. When I look at the list of queues in the default SMPT virtual server there are a ton listed. Most of the entries look like this: SmallBusiness SMTP connector - thome.palkiss.net (SMTP Connector - Remote delivery) There are...

I'm getting a ton of the below errors in my event log. Can someone shed some light on what this is and how to remedy it? Event Type: Error Event Source: NETLOGON Event Category: None Event ID: 5774 Date: 8/31/2004 Time: 4:45:35 PM User: N/A Computer: MVDNT1 Description: Registration of the...

My company needs a solution to print barcodes on our orders for the warehouse to scan. We were considering buying a barcode DIMM for our HP printers but were hoping for a software solution. I'm not sure if this is possible but it would basically need to print a plain text file and have certain...

Hello, We sometime get emails bounced back to us saying: "The server sending your mail [xx.xx.xx.xx] does not have a reverse DNS entry. Connection Rejected" How do I set up a reverse DNS entry? This is our setup: We host our own Exchange server so when we sent email it is coming from our IP...

Hello, I need to create a script that will strip out all the carriage returns from a text file. The text in the file I'm being sent is supposed to all be on one line with no breaks, but the other person's software is inserting CRs supposedly when it is FTPed. Any help would be appriciated...

I left my PC on yesterday while I was at work and when I came home it was off. Hit the power switch and nothing. Other devices plugged into same surge protector work fine power cable is fine. I assumed it must be a power supply problem so I took it out and put in the PS from my old PC. Still...

Today I notice our server is running slow. Didn't really think much about it but decided to do a reboot. After the reboot our ScanMail monitor starts up first and I notice a ton of emails going through it. I watch it a bit and it's doing like 1000 emails a minute. So now I'm trying to...

A home user awakes to find his PC "locked up". He turns it off and then it wouldn't boot up. He brings it into work (this is where I come in) and as soon as I turn it on I notice the harddrive is making a very loud whirling noise. So I tell him it seems is harddrive is dead (I put it...

I added SCSI card and SCSI hard drive to my PC and I cannot access it. XP recognizes both the card and the drive and the drive shows up in Computer Management but I can't access the drive in Windows Explorer or any other way. In event viewer I am getting the error "The driver detected a...

I have two tables which I usually join to create a result. I want to add to the query another table. All 3 tables have the same primary key field. I want the query to return all records where table1.key = table2.key only where key is not contained in table3. I tried this query first...

Is there a way to create a date/time in Unix time stamp format in ASP? I need to convert a date in "mm/dd/yyyy" format. thanks

I just want to display how long it took a page to process. For example on search engines it will say "search took .07 seconds". I'm assuming there is a server variable, but I can't find it. thanks

I created an asp web page to manipulate data and I'm using a web query to get that result into a spreadsheet. The problem is two of the fields, stock# and UPC, have leading zeros. When importing via the web query it imports it as a number which get's rid of the leading zero. Does anybody know...

I purchased a shopping cart solution called XCart which uses Smarty templates and MySQL. The way it handles images of products is to store the actual image in the database. This doesn't work for me so I created a field in the products table called "imageName" and I want to just...