I believe you're right. I have updated (SP3) BOL and it too shows 1=failure. My MSDB..sysdbmaintplan_history contains all 1's (well, nearly all) and I can assure you they've...

Well done. Did you use Profiler to track it down?

Cheers,

- Mark

Yes, the function is new to sql2000.

Cheers,

- Mark

Is this for the "Frank Kalis - Employee of the Month" website?

Cheers,

- Mark

booze = wein, bier, schnapps

fridays = a day in Australia where everyone turns up for work, but very little is done

lunch = mittagtrinken

arvos = afternoons

Cheers,

- Mark

Adam,

For both the UPDATE and DELETE scenario, whether it's a single row or multiple rows affected, your trigger can refer to the "deleted" table. An example follows.

(nb. For demonstration...

quote:

---

Is there an equivalent of @@ERROR for the error messages?

---

I wish there was,...

Anything new implemented on the server last Thursday/Friday? Or, any config change at all?

Cheers,

- Mark

You should be able to restore anytime up to 12 midnight using the 11pm (and prior) transaction logs, plus a portion of the 1am tran log backup. The full...

The syntax problem is that your subselect, ie:

 

(SELECT SystemUserName ....

.... <> 'valverde\rKepler')

is expected to return a single value, which then must be compared with...

As an extension to guarddata's response, you may choose to block the invalid inserts at the table definition, with somethin like the following. The error message generated is readable...

That's true. But you need SQL2000 running under DataCenter rather than Advanced Server (see "Maximum Capacity Specifications" in BOL).

Cheers,

- Mark

Well done Frank. All that hard work's paid off.

What are you going to do when they find out you're spending most of your day solving other people's problems... and...

quote:

---

I like your structured problem solving approach!

I lack this sometimes

---

I thought you...

Ramesh,

One set-based way to do it without a cursor is to use a UDF to return the concatenated col2 fields for each col1.

Cheers,

- Mark