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 Wanet Telecoms Ltd 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: *

  • Users: TB0NE
  • Order by date
  1. TB0NE

    Delete Query with multiple relationships

    Thanks again scriverb. It's guys like you that make my job a whole lot easier. You get a star.
  2. TB0NE

    Delete Query with multiple relationships

    Thanks scriverb! That worked perfectly. Can you tell me what was wrong with my query? What is your query doing that mine was not? Thanks again! TB0NE
  3. TB0NE

    Delete Query with multiple relationships

    ...query against it. I don't know squat about SQl, but maybe it will help you to see it. Here is my delete query in SQL view: DELETE computers.*, Q_SearchExpiredScanDates.computer_name FROM computers INNER JOIN Q_SearchExpiredScanDates ON computers.computer_name =...
  4. TB0NE

    Delete Query with multiple relationships

    I am trying to run a delete query in a database with 34 tables. 33 tables relate back to the main table which also contains the only primary key in the database. I created a query to delete records from the main table (Let's call it 'ComputerInfo') but I get the error "Could not delete from...
  5. TB0NE

    Recipient Policies and Error 8325

    ...had multiple Event ID 8325 s refering to the MSExchangeAL service. The error is as follows: The service can't work properly because the Policy 'CN=**policy name**,CN=Recipient Policies,CN=**Company Name**,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=**domain name**,DC=com' has an...
  6. TB0NE

    Recipient Policy applies incorrectly

    ...had multiple Event ID 8325s refering to the MSExchangeAL service. The error is as follows: The service can't work properly because the Policy 'CN=**policy name**,CN=Recipient Policies,CN=**Company Name**,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=**domain name**,DC=com' has an...
  7. TB0NE

    Sender Denied Error in Exchange 2000

    I am running Exchange 2000 with the latest service packs. I am having trouble receiving email from 1 domain and only under certain circumstances. The scenario is as follows: We have an ASP in Florida that hosts our HR database. When we need support from them we email to...
  8. TB0NE

    Logon script as administrator

    jonwilbanks, I have the same issue. Currently, I have a script that calls on a program to scan the users computer (inventory). The program runs but it does not catch critical data due to the fact that the user does not have administrative privileges to the local machine. If I run the same...
  9. TB0NE

    Hosting 2 domains on Exchange 2000

    ACraib or DaShard, I was going to start a new thread but you are discussing the exact issue that I need help on. What steps are required to set up a second domain in Exchange 2000? Is is necessary to have an MX record in DNS and if so, do I create another domain or another zone. Also, other...
  10. TB0NE

    TransferDatabase Macro needed

    Thanks DaltonVB! Especially for laying it out for me with the comments. Gimmie a chance to digest it and I'll try it tonight.
  11. TB0NE

    TransferDatabase Macro needed

    This may require some VB work but I was hoping for a simple macro solution. However, any ideas are welcome. I have 15 identical databases in 15 cites (structure is the same, obviously the data is different). I need to import the data from each one of these databases into one master database...
  12. TB0NE

    User Profiles taking as long as 5 minutes to load!

    dholbrook, That's good advice. I will try that for my desktop users. I can't do that however, with my laptop users since they travel so much. Unless you feel that offline folders would be more efficient? What say you?
  13. TB0NE

    User Profiles taking as long as 5 minutes to load!

    Deik313, I'm 99% sure your roaming profile load time is not related to your ISDN config. I too have roaming profiles for a network of about 50 users. We did this to insure that a copy of the users 'My Documents' directory and 'Desktop' resided on the file server. Essentially we made it a no...
  14. TB0NE

    Security Policy and User Rights

    I have a HW/SW inventory program that I deploy to each client through a logon script via group policy. The program work great but fails to retrieve BIOS information from the client PC when the user is in the Power Users group or in a lower priviledged group. If the user is a local machine...
  15. TB0NE

    Need help on a tough query. A challege.

    Thanks John! The Cross-Tab query did the trick. My solution was actually more simple than the thread you refered me to but that definitely pointed me in the right direction. Thanks for the tip! For anybody that may be interested, I did the following: I created a cross-tab query against the...
  16. TB0NE

    Need help on a tough query. A challege.

    ...network_adapters.adapter_name, logical_drives.logical_disk_total HAVING (((network_adapters.adapter_name) Not Like "*Loopback*")); This works fine if I only need the capacity of the C: drive but I cannot get the the D: drive to show up on the same line. This is because the...
  17. TB0NE

    Exchange Maintenance

    Thanks for the input! I am running McAfee GroupShield 5.1 and NetShield. GroupShield is responsible for not only scanning messages but also quarantine and attachment filtering. I currently allow only 8-9 known file types. McAfee can be a hog. There are no other 3rd party apps besides this...
  18. TB0NE

    Exchange Maintenance

    Thanks RobbyB. I'm glad to here about the memory utilization and yes, I back up religiously. I do have quite a lot of SMTP queues. This is, in fact, a lot of SPAM replies. I periodically go through and delete these from the queue. I average 50-60 individual queues with some containing as much...
  19. TB0NE

    Exchange Maintenance

    I am relatively new to Exchange and am in need of some advice. I have a dual PIII 866MHz w/ 1.5GB ram running Exhange 2000. I have 36GB of disk space using RAID 5 with 20 GB free. Periodically (every 30 days) I have to either restart the information store or restart the entire server because...
  20. TB0NE

    Mapping Drive problem with VPN

    Update: I have tried mapping via IP address with the same result. I have also setup a host file to resolve the name to no avail. However, name resolution does not seem to be the problem. I can ping by name and by IP address. I can also access the mail server using the full Outlook client. To...

Part and Inventory Search

Back
Top