Hi

With the local hard disk, we also encounter the same List Volume error in Cluster validation.

Regards,

Hi Perry,

The validation test passed successfully during the initial setup. After the problem occurred weeks back, we run the validation test again and encounter the this error

List Cluster Volumes

An error...

Hi,

Then how about to have BEFORE Trigger? Like the following,

CREATE TRIGGER Product_tBeforeAfter800

on dbo.Product BEFORE update

CREATE TRIGGER Product_tBeforeAfter800

on dbo.Product BEFORE delete

CREATE TRIGGER Product_tBeforeAfter800

on dbo.Product BEFORE insert

Thanks

Ken

gohsiauken (8/18/2008)

---

Carl Federl (8/16/2008)

---

Additional comments:

The SQL Standard allows multiple triggers on a table for the same action

and allows specification of the order with the SEQUENCE keyword but

SQL Server allows...

Carl Federl (8/16/2008)

---

Additional comments:

The SQL Standard allows multiple triggers on a table for the same action

and allows specification of the order with the SEQUENCE keyword but

SQL Server allows multiple...

GilaMonster (8/16/2008)

---

You can.

What would probably be best is to make the entire thing handle an number of rows (set-based processing instead of row by row) and then use a...

GilaMonster (8/15/2008)

---

Better but you're still assuming that there will only be one row in the inserted tables, example the following line

SET @ProductID=(select ProductID from inserted)

There could be any number of...

Hi, this is the edited version after your advice.

CREATE TRIGGER NewSaleItem

ON SALEITEM

AFTER INSERT

AS

BEGIN

SET NOCOUNT ON;

Declare @UpdatedQty int,@Subject as varchar(200), @Body varchar(8000), @To varchar(50),

@From varchar(50),@ProductID int, @Quantity int

SET @UpdatedQty=NULL

SET @Subject=NULL

SET...

Hi All,

I am sorry that mis-post the earlier question. Just get it updated.

If this is not the correct way to write a trigger, can anyone tell me hwow to create...