I know this is a SQL forum, but there are times when I, and this is just me, find it easier to do...

What sticks out to me is you did not name the data type of @sql when you declared it.

Garadin (10/28/2008)

The first question is, how important is this data?

Also, does that sp actually run for you? I'm getting invalid length parameter passed to substring function based on the...

Seth

Thanks for the reply. Probably I should have mentioned that I am using the result set only as a starting set of job numbers. Certainly there are going...

sel, you could try something like this

CREATE TRIGGER tr_test_trigger

ON YourTable

FOR INSERT

AS

IF @@ROWCOUNT = 0 RETURN

IF (SELECT COUNT(*) FROM YourTable) > = 400

BEGIN

Run your alert...

Good luck, and note that my solution above will work for you, as I tested it on an Oracle server. In Oracle, || replaces + in concatanation.

The OP is using Oracle,...

I don't believe you can update a substring of a field in place. What you will have to do is add the portion you want to keep to the...

Molly, maybe this would be easier...

WHERE DATEDIFF(m,asofdate,GETDATE()) < = 13

This will show them to you...

SELECT

*

FROM tblAdd

WHERE address LIKE '%"%'

To remove them, look up REPLACE in BOL.

Ahh, what relief. I get it, the trigger would fire when it updates the field in question, which would cause it to fire again. Never thought of that....

Now wait a minute...no one ever mentioned that one to me before. I'm not sure exactly what that means. ...

John, that's a pretty subjective question, but there are countless auditing methods out there. I found one...

John

I'm not sure about a MDB, but with ADP, all permissions come from the Server, not the Access front end. I believe the a MDB has built in user...

John

Did you grant insert permission to public on tblAuditLog? That might cause it to not work for others. Just a thought.