Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TheMikeh

    Which software is best for remote backup?

    Hi peeps, Right where do I start, basically I have a server room here with 3 servers as follows PLUTO -> File server (60gb, approx 100mb change an hour) NEPTUNE -> File server (140gb, approx 150mb change an hour) EARTH -> SQL 2005 (30gb uncompressed raw) Now I also have a server and SAN that...
  2. TheMikeh

    Update a field based upon another table

    Hi, Many thanks the following seems to have done the trick! UPDATE contact2 SET ulastpropa = ( SELECT max(lastdate) FROM contsupp WHERE contact2.accountno = contsupp.accountno AND rectype='R' ) Thanks Mike
  3. TheMikeh

    Update a field based upon another table

    Hi, I have two tables (structures as below) and I need to update the first one to match a date from the second table. The tables I have are CONTACT2 accountno | lastdate CONTSUPP id | accountno | rectype | lastdate Now in this for every record within contact2 there can be 0 to unlimited...
  4. TheMikeh

    DHCP not working

    DNS has never been running on our PDC as endian has support for AD enviroments. Just for your information Ive finally fixed the problem! Turns out there was a Mac Timecapsule which was trying to issue IP's via DHCP due to the user plugging the cable into one of its ethernet ports not its wan...
  5. TheMikeh

    DHCP not working

    10.10.254.1 = endian firewall 10.10.1.2 = primary domain controller Services IP's sit on 10.10.1.x DHCP IP's sit in 10.10.100.x Static IP's sit in 10.10.101.x Printers IP's sit in 10.10.102.x Fax Systems sit on 10.10.103.x Avaya Phone system is 10.10.2.2 Avaya Phones are 10.10.2.x Subnet is...
  6. TheMikeh

    DHCP not working

    Standard/basic ones are 003 Router = 10.10.254.1 006 DNS Server = 10.10.254.1 015 DNS Domain Name = chelco.local 044 WINS/NBNS Servers = 10.10.1.2 046 WINS/NBT Node Type = 10.10.1.2 And its set to distrube IP's from 10.10.100.1 to 10.10.100.200
  7. TheMikeh

    DHCP not working

    No no, let me explain ... The wireless network is 100% independent, its literally a ADSL2 modem and 2 access points used to give internet access to our guests/visitors. Our main network has no wireless at all and is fully cabled, virtually every device is running from static IP's and those...
  8. TheMikeh

    DHCP not working

    And yes, when set to static IP's all machines connect and run flawlessly, my laptop was static hence why I never noticed it and the other users saw cable didnt work and just flicked over to the net as they only really need internet ...
  9. TheMikeh

    DHCP not working

    The wireless is a seperate network all together, its purely internet access via 2 access points, its seperate from the wired network due to security. I have a program called DHCP find and when you click the button the right DHCP server returns a valid IP address, its just the laptops pick it up...
  10. TheMikeh

    DHCP not working

    Yes sorry just realised that there is a single XP laptop that is also doing it, but even then it seems a bit odd that every laptop would suddenly develop this problem? I will try anyway though just to rule it out.
  11. TheMikeh

    DHCP not working

    In response to the very last post, I cant see how firewall on the machine and deleting/reinstalling the nic will work because its all laptops with the problem (5x vista, 1x winxp pro). Will give all suggestions a go and Ill read that link, thanks
  12. TheMikeh

    DHCP not working

    Hi, Ive checked all our switch's and they have a DHCP Relay option which I have tried turned on and turned off and either way it had the same effect. If I plug the cable into a machine, the system says 'identifying' and then after a few minutes it then goes to 'unidentified network' and is...
  13. TheMikeh

    DHCP not working

    Hey, Basically we have a small business network consisting of 6x servers, 30 client machines and 5 managed POE switch's. We then have an endian os firewall on a server which manages routing etc. Now DHCP has and always was enabled on our primary domain controller and worked fine, however all...
  14. TheMikeh

    Avaya IP Office - Wireless?

    Only 64k per call? that's great, for some reason I had a higher figure in my head on that one! May I ask which AP's you would recommend for use with the linksys? And kholladay? I really dont understand your post, sarcasm? hmm
  15. TheMikeh

    Avaya IP Office - Wireless?

    So in essence im basically looking at producing 'mini' networks on each 'pod' of desks and then using wireless 'bridges' to fill in the gaps? What worries me is would 4x phones and 4x computers run from one single linksys bridge without bandwidth/data issues?
  16. TheMikeh

    Avaya IP Office - Wireless?

    Does the Linksys WRT54G provide POE? or does this introduce another issue? for example would I need to take the ethernet from the WRT54G and then put this into a POE and then into the phones etc?
  17. TheMikeh

    Avaya IP Office - Wireless?

    Hi, Right, got a bit of a dilemma here but I basically need to network an office of 30 computers and 8 servers wirelessly for a period of 12 months due to restrictions on the building and structured cable (listed building etc) I have 1x Avaya IP Office 406 I have 30x Avaya 5602SW IP handsets I...
  18. TheMikeh

    Stored Procedures! Help

    Hi, Ok no worries after a few hours found my silly little mistake! I wasnt declaring the username correctly, silly me! The final code Im using in case anyone is interested is ------------------------------------------------------------ CREATE PROCEDURE dbo.GrossProfitGenerated ( @userID...
  19. TheMikeh

    Stored Procedures! Help

    Hey, I have a database that holds a list of figures combined with a open date and an end date. I need to grab a SUM of all the figures whereby the end date falls within a set date range. I need this as a stored procedure where by I can pass the userid in 'foreign key' and 2 dates to get a sum...

Part and Inventory Search

Back
Top