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 bkrike 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: leprikon
  • Content: Threads
  • Order by date
  1. leprikon

    Track table deletions / adds

    The error log shows who logs on, backups etc .. but doesn't show when a table is created in a database or when a table is deleted. How do I track this in SQL 2000 Server ?
  2. leprikon

    Round Robin & Split DNS

    I have two web servers behind a pix firewall. The outside world can got to 207.0.1.1 or 207.0.1.2. The pix translates to 10.0.1.1 & 10.0.1.2. the dns servers have 207.0.1.1 & 1.2 plus the 10.0.1.1 & 1.2 host records. If i don't enable round robin .. users on the private network goto 10.0.1.1 &...
  3. leprikon

    TCP/IP Filtering

    I have a web / dns server. I configured IP Filtering with the following : TCP 25 21 80 443 53 UDP 53 But the DNS query isn't working. I am wondering if the DNS server is forwarding the request on say port 1003 to our ISP DNS port 53 (which would work with the rules above). But the remote DNS...
  4. leprikon

    Trafic Shapping for VOFR

    I have a hub and spoke setup with a few agents in remote branches (no more than 4). Each branch has a 128k Port with a 64K cir. We are testing SIP phones at one of the branches. I am getting a second PVC for that remote site (64k) and bumping the port up to 192k. How do i tell both routers that...
  5. leprikon

    DNS Setup using a pix

    Here is what i'm setting up - is that a fairly common practice or is this not recommended ? internal DNS on 'Private' forwards to external dns on 'DMZ' who forwards to ISP DNS. When a query for a local domain (test.domain.com) the local dns server queries the dmz dns server and since the...
  6. leprikon

    Can i use a trigger to create a txt file into a shared folder ?

    I want to use a trigger on fieldA for certain records so when fieldA gets populated, i can create a txt file in a share with data from the updated record. Is this possible ? Example : As shipping prints orders the order gets assigned a pikslip. If the order is for certain companies i want to...
  7. leprikon

    Need help with Trigger

    I'm trying to modify a field on the record as it comes in if it meets certain criteria. What am i doing wrong ? CREATE TRIGGER Shipping_Instructions ON dbo.table1 FOR UPDATE AS BEGIN update dbo.table1 set shdel2 = 'Special Requirment' where shan8 IN...
  8. leprikon

    Select statement help (multiple record sets)

    How would i select out the first records for each series below ? 12345 Abc123 12345 Abc456 12345 Abc756 22222 Bhgggg 22222 Gkjgkg 22222 jgjgjj 31111 kjlfdj 31111 lekf;r I only want : 12345 Abc123 22222 Bhgggg 31111 kjlfdj
  9. leprikon

    Gentran Server for Windows Email from a map ?

    Hi we're using Gentran v4 & JDEdwards OneWorld Xe. I'm trying to add an email to the map so that when the 850 or 860 comes in, Gentran will create the flat file for JDE and fire off an email to an operator to verify that the po# with the detail lines in the email are matched with the genterated...
  10. leprikon

    setting up dmz => private access for smtp

    setup : outside :xxx.xxx.xxx.xxx private 192.168.1.100 exchange dmz 10.0.1.100 iis smtp currently i can get from private to dmz (telnet 10.0.1.100:25 from 192.168.1.100) when trying to telnet from 10.0.1.100 to 192.168.1.100 the syslog display that its just denied (no acl defined in error -...
  11. leprikon

    Ability to log allowed access-list on pix515 ?

    I've been using kiwi syslog for a while with our pix 515e. It's great for seeing denied access via access-list. How do I show permitted traffic however ? access-list 103 permit ip host 192.168.1.x any log log parameter doesn't work. Would i have to log at the information level instead of...

Part and Inventory Search

Back
Top