Recent content by leprikon

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 ?

This method seems to work if we manually export the data. But when setup thru proccess control i get an error stating : Other ActiveX error: no system message defined Method: Send On End Rule, group name = %1 Here is the end rule : object oOutlook; object oMail; oOutlook =...

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 &...

Qwest is telling me i don't need a seperate DLCI on the host side .. just the Leg. How would this work if i want to send all voice over a seperate pvc ?

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...

hrm, looks easy enough. what does the London side show ? Any chance you can shoot me over your configs so i can compare them to mine (which currently has 3 lines per interface and not utilizing any ACL) ? :)

I have it setup as static outside to dmz then use acl to control access. I was more concerned with the issue of forwarding to the dns server on the DMZ instead of having the inside go out to the ISP directly. But there doesn't seem to anyway around it.

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...

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...

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...

should be on insert then ?

as each record is written to table1. If the value of field shan8 is equal to '202010','202012','202167',or '202564' then set the value of field shdel2 to 'Special Requirement' on the inserted record. Basically we have our Cust Department not entering notes on each record, which is needed by...

what is the following doing ? (SELECT trigger_nestlevel( object_ID('Shipping_Instructions') ) ) = 1

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...

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