Search results for query: *

Hello, I need some help on this one. I've migrated an application from Win2k/IIS 5 to Win2003/IIS 6. The code hasn't changed. I have a function that I use often throughout my application that I include into each file with <!--#include file="start.asp"--> When I open the app, the home...

Hello! Here is what I have: select (select sum(b.billings) from tbNumbers as b where b.datestamp between dateadd(d, -6, a.datestamp) and a.datestamp and b.user_id = a.user_id) as metric_week, a.datestamp from tbNumbers as A where a.user_id in (64, 152, 72, 118, 95) and a.datestamp...

Hello All, I need some help. I've done a few Google Searches, and searched this forum but am not seeing a good answer. Here is what I am trying to do. It's actually kind of simple. I am trying to get a list of user id's from users (stored in tbMembers) that belong to an office group...

I'm trying to put together a single stored procedure that I can pass a number to. It will then return me the percentile that number was compared to a group, as well as the max, min, median, 75th percentile, and 25th percentile numbers from the group. I put together a nifty little script that...

Here is a challenging algorithm I need help with: I have a table called tbNumbers that stores billings values per user per office. Each record has a datestamp. Here is an example of some data from the table: id user_id office_id billing datestamp 1 15 1...

Hello. I just purchased a new server with a single Xeon Processor with HyperThreading. HyperThreading came enabled from the vendor and Windows Server 2003 was pre-installed. The HAL is set as an ACPI Multiprocessor HAL. The software I'm installing on this server is a call processing...

Not sure if this is possible, but it would be nice if it was. We currently use Exchange 2000 with Outlook XP as the client. But a database program we use in-house needs to be able to send/receive email using the POP/SMTP protocols. That part of it works fine... but would be awesome as hell...

Hello, I am attempting to program a pretty challenging Stored Procedure in SQL 7. I thought I'd put it up on here because you all might think of something I have not. Here's what I'm trying to do. I am trying to do a real time desk count for users in an office for a reporting time period...

I have a strange problem I'm hoping someone can help me with. I run 2 Windows 2000 servers, one with Exchange 2000. On both I have them set up as DNS servers. Well, every now and then... with increasing frequency the DNS starts throwing errors that certain records cannot be found. It...

Hello, I run a small Exchange 2000 server. Today, for no reason that I can tell email stopped sending out. From Outlook it leaves the Outbox and appears to have been sent. But after someone brought it to my attention, I can see the messages sitting in the Queue of the SMTP service in...

Hello folks. Disclaimer: I did not design the database I am about to tell you about. I am merely trying to use that database. Here's the thing... my office uses an application as our contact management database. I am trying to write a website in ASP that will allow access to this very same...

Hello all, I'm trying to do something with T-SQL in a Stored Procedure, that I imagine is possible but so far have not been able to do. Hopefully someone here can offer some insight. I have a program, that reports on user's sales totals for my office. The basic output of the query is a...

Hello everyone, I am in the process of replacing my older computers running Win 2000 Pro with computers running Win XP Pro. I had my network set up to use Folder redirection to redirect Desktop and My Docuements to the server. It worked great in Win2k. The problem is that with these new...

Hello all, I just noticed this problem today, and can't find a solution. Basically, when I add a user to the AD Users and Computers that came with Exchange, I enter the username/password just as I always do. Then it asks if I want to create a mailbox in Exchange. I say yes, and its done...

Hi all, I've been using CDONTS on my ASP pages for sometime without any problems. A couple weeks ago, I performed some security updates on the OS, and CDONTS has not worked since. I've made no changes to the code at all... it is still written exactly the same way it was when it was working...

Hi everyone, please help me with this one. I'm moving my exchange users from an old server to a new one for better performance. I wanted to do this with 0 downtime, so I'm using a new server name. I set up the new server, installed Exchange 2000 on it, upgraded to SP3. So far I've been...

I have to Domain Controllers running Windows 2000 Server. For whatever reason, today the two stopped updating changes to Active Directory between the two of them. Changes made on Server1 do not appear on Server2. Is there a way to manually make the two servers update their Active...

I am trying to delete some old users from Exchange, and am having a problem. The Purge option is greyed out when I right click on a user's mailbox in System Manager. I then right click on &quot;Mailboxes&quot; and click &quot;Run Cleanup Agent.&quot; The screen refreshes, but nothing happens...

Here's my problem. I have only one IP address to use for the web. And three domain names: www.reagansnet.com, www.phantomatrix.com, and www.ilneco.org. I want to make an index.asp page that contains only a sinple case statement to redirect to different pages with different site designs based...

I need help finding the correct sql statement to increase the size of a varchar field in my database. I underestimated the size I would need. I have tried this: &quot;alter table tbWeeklyReport modify (q1 varchar(1500), q2 varchar(1500))&quot; But I get an error near the &quot;(&quot; before...