• Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • Need to create a bootable server 2003 CD

    Hello, I have a burned copy of Server 2003 Enterprise edition that a friend gave to me. I'd like to install it on my test server, but am unable to because the CD is not bootable. I have tried booting the server with a 98SE floppy boot disk but am unable to run setup through DOS. I currently have a...

    Kfettig5 pointsBadges:
  • Command for auto reboot – Windows 7

    I am trying to set up an auto-reboot script to reboot my Windows 7 workstations. I have the following command set up as a batch file and set up to run using task scheduler:shutdown.exe /rIf I have an open document with changes that have not been saved, the command I have used will not save the...

    Ricopersaud145 pointsBadges:
  • Configuring VLAN’s on two HP procurve switches

    Hi all, Trying to route a new ISP(Microwave link) from one of my out building to my computer room and hence my firewall. Old ISP came direct into firewall. In the outbuilding the Microwave modem connects with cat5 to HP Procurve 2524 switch. Because this ISP is coming through my internal network, I...

    Pandub130 pointsBadges:
  • Receiving undeliverable email we did not send

    Hi everyone, One of our users keeps getting undeliverable email messages. It looks like someone out there is sending mail and making it look like it is coming from him. Is there anyway to stop this? We are running Exchange 2007. I don't think it is relaying or a virus. It does this even when his PC...

    Fuddstud0 pointsBadges:
  • I need to Install a .Reg file into registry SILENTLY

    Hi Folks I need to Install a .Reg file into registry silently! On a question I posted here a month ago, I asked about preventing the dreaded "Desktop Recovery" appearing for no reason after a re-start OR cold boot. Because of the answer I got here on this site, I was able to track it down to a...

    MacsPC235 pointsBadges:
  • How do I check what licensing mode a server is on?

    How do I check what licensing mode a server is on?

    Shiqu25 pointsBadges:
  • Driver required for Dlink Dub-E100 USB-Ethernet on Windows 7

    Hi, I am using Win7. The USB-Ethernet adapter of Dlink 'DUB-E100' shown here. The msdn website says, no need to install driver but Windows 7 doesn't detect automatically. The CD and its website doesn't provide driver for Vista and Win7. I tried doing it in 'compatibility mode' and 'adding a legacy...

    Ubuntuv40 pointsBadges:
  • Why does Excel keep crashing?

    I have a relatively small file used for work. It contains 20 worksheets (most have very little information, or none at all, which all work fine except for one of them. It WAS working fine, but now every time I try to add or delete a row (which I have to do often) Excel 'encounters an error and...

    ATCPurdue65 pointsBadges:
  • Backups failing due to volume shadow copy

    On a Windows Server 2003 standard machine, I have set up NTbackup to run daily. For the first couple of weeks the backups ran smoothly, but now every single one fails with the error: Volume shadow copy creation: Attempt 1. Timeout before function completed Error returned while creating the volume...

    OwenAmbrose1,930 pointsBadges:
  • Multiple DHCP Scopes for multiple VLANS

    I am using Windows Server 2003 as a DHCP server. I would like to have centralized DHCP management using the one server to give out addresses to each of the 3 VLANS. We are also using Cisco switches and I planned on using the dchp-helper to allow the DHCP packets to be forwareded to the server. I...

    Skepticals0 pointsBadges:
  • Offline files not working Windows 7

    Hi all :) I have a strange problem with a Windows 7 pro user. I have enabled offline files but when I right-click on the shared folder I get the option "always available" but when I click on it nothing happens. It is not that the option is greyed out or not there, it is there but when selected...

    TracyGS70 pointsBadges:
  • How to add users and computers (XP) to Windows Server 2003: Step-by-step

    Hi,I am new to networking. How do I add computers and users to my server 2003 in a network of DNS auto detection. Please provide any directions to stabilize my mind and system in network doesn't accept the domain of my server 2k3. How do I set it?

    Ayesh25 pointsBadges:
  • How to increase mailbox size of users in mailbox store

    How do I increase my mailbox size of users in mailbox store?

    Z65 pointsBadges:
  • Disabling USB flash drive use via group policy

    Do you know of a way to effectively disable USB flash drives while permitting other USB devices on client computers through a group policy? Our systems administrator has tried a couple of alternatives, but some of them completely disable the USB ports, and others just block some specific types or...

    carlosdl69,835 pointsBadges:
  • Connecting two Windows 7 machines via WiFi?

    Can I connect two Windows 7 machines together via WiFi without using a router? I need to copy files both ways and the only connections in common on both machines are WiFi 802.11 N.

    ITKE347,785 pointsBadges:
  • USB External Hard drive and Windows XP

    I have two issues which are basically the same. I have an external USB hard drive that I connect to a computer running Windows XP. Windows USB driver recognizes the hard drive and shows the drive in Device Manager but Windows does not show the drive in Windows Explorer. A customer has a USB FLASH...

    Cestanley0 pointsBadges:
  • How to run *.CMD files

    How do I run *.CMD files?

    Mkdesign15 pointsBadges:
  • Send email w/attachment from Command Prompt via batch file

    Most users at my organization have all of the utilities to keep their computer running smoothly, but fail to use them on a regular basis if ever. I have written a few batch files which execute all of these programs, clean this, clean that, defragment, and so on and so forth. Each time the file...

    Schmidtw11,330 pointsBadges:
  • Slow opening MS Office files on computer

    I have a user who is having trouble opening only Office files on his computer. When you open the application and then open the file, everything is fine. But when you double-click the file in My Computer or from an email it takes upwards of 3 minutes to load the app and then the file. Last time this...

    Dpiccus20 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following