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!

Recent content by Sunny4Ever

  1. Sunny4Ever

    Replicating AD integrated DNS

    Thanks for your reply. Reloading a zone will not force AD replication so will not help me in this case. Also I need an automated solution.
  2. Sunny4Ever

    Replicating AD integrated DNS

    Hi All, I have been trying to use repadmin to force AD Integrated DNS to synchronise an A record change without having to wait for normal replication cycle. I have run repadmin /syncall MyDomainController DC=DomainDNSZones,DC=MyDomain,DC=COM However while testing this it does not look like...
  3. Sunny4Ever

    Incorrect unread item count in Folder List

    Hello, Using Outlook 2002 with Exchange 2003. One user has an additional mailbox which they view in their standard Outlook folder list . The problem is when the number of unread items in the Inbox is <=10 then they do not see any number in brackets next to the folder to indicate unread items...
  4. Sunny4Ever

    How to Calculate Avg. Price from the following table

    Good job amrita you have reverse engineered the required formula. One problem I can see however is the case where: sum(a.qty_recd - a.qty_sold) = 0 For this case you will have to add some extra code or get killed by a div 0 error: --------------------------------------------------------...
  5. Sunny4Ever

    How to Calculate Avg. Price from the following table

    My Observations: Your formula results in a Div 0 error for the first row of data? Is this correct? How does this formula give you an average price ???? Are you actually after something simple like this: SELECT ItemCode, AVG(UnitPrice) As 'Avg.Price' FROM ITEMS GROUP BY ItemCode If not then...
  6. Sunny4Ever

    script to get nofified when certain Event ID occurs in the Event log

    Sorry markdmac but that is not the problem. Aside from having put a space in the ipaddress variable which will cause this to fail I think it may be something to do with XP SP2. Do you have the firewall enabled?
  7. Sunny4Ever

    Error Handling

    I also find it useful to ping the remote host in the script before trying to run a WMI as the timeout is lower for ping.
  8. Sunny4Ever

    Unable to log on with User A/C

    Hi - the following link will help you: http://www.petri.co.il/logon_locally_user_right.htm
  9. Sunny4Ever

    script to get nofified when certain Event ID occurs in the Event log

    My first question would be what OS and Service Pack are you running on the remote machine? Secondly are you running the script under an account with Admin rights on the remote machine?
  10. Sunny4Ever

    script to get nofified when certain Event ID occurs in the Event log

    Hi, The following script will listen to your local system and then send a mail when eventid 0 occurs. Change strComputer = "." to strComputer = "MyHost" to listen to a remote machine. Change TargetInstance.EventIdentifier = '0' to the number of the EventID you wish to trap. Also you will...
  11. Sunny4Ever

    registering dlls

    You need to narrow your scope down a little. 1) When you say find unregistered dlls I take it you mean DLLs which exist on the local file system but are not registered... 2) When you say register all dlls again I assume you mean those on the local file system... It should be noted that only...
  12. Sunny4Ever

    VBS Login Scripts

    And my apologies for pinkpanther bashing ;)
  13. Sunny4Ever

    Nested select problem

    Ooops - sorry misread the brackets. How about putting a final 'AS Newtable' at the very end?
  14. Sunny4Ever

    Nested select problem

    You are trying to select a table and this is not supported and will fail! You can only use select to select specific fields or by using the * all fields. in your code 'but' is a derived table with 2 columns. You could use: select * from (select bte.buildfile, max(bt.buildtime) as but from...
  15. Sunny4Ever

    Understanding NTP

    Not sure what you should do with your 98se machines (except maybe upgrade them) but for the XP machines you should start by checking out this link http://support.microsoft.com/default.aspx?scid=kb;en-us;307897&sd=tech

Part and Inventory Search

Back
Top