Hi Richard,

I Agree that  INSERTED and DELETED tables have blob fields within INSTEAD OF triggers.  Thank you for correcting the mistake. However, I disagree with what you say with UPDATETEXT/WRITETEXT.  If you...

SprocKing says: "I implemented audit triggers on tables with both text and image columns in them. The problem is that you can't refer to binary columns in the inserted and...

You can use stored procedure if all your Create/Update/delete operations happen through stored procedures only. 

Definitly it will improve the performance.  I have implemented certain operations (not auditing) through  triggers...

Author says:

What the INSTEAD OF trigger does is override the normal insert,delete or update statement and leave that responsibility to your Trigger. You will be responsible for inserting, deleting...

I am replying after a looooooooooooong time

On the first method the author is using a not so optimized query.  He is using different methods...

In addition to the above pure TSQL methods, you can try another option using any of the .net language. 

SQL Server 2005 comes with another new feature called user defined aggregates. ...

I have think of two solutions:

Solution 1:

Declare @VehicleNo varchar(10), @Damages Varchar(50)

Create table #Damages (VehicleNo Varchar(10) , Damages Varchar(50))

Select @VehicleNo =''

Select @VehicleNo = Min(VehicleNo) from TBL_Damage Where VehicleNo >@VehicleNo

While @VehicleNo is...

On item 2,

Transaction is there to maintain atomicity.  That means either 100% of the code is executed without error or none.

If you have only one direct insertion to...

This is the formula: Union = Union All + Distinct

When you use UNION it will display only the distinct records.

Please use UNION ALL if...

Is your stored procedure run as a transaction?

You need to ask find afew points:

How Big is your table?

Do you have a clustered index onthe table?

Is there any other services running (and consuming more memory) on the same...

There is a primary difference between ROWID of oracle and Identity of SQL Server.   You ROWID is implicitly available in Oracle.  In SQL Server You need to add that column.

I...

Therre are a few things you can check on.

Maximum memory allocated to SQL Server (on EM, check on properties)

Updating the tables with triggers will definitly will more work to...

I agree on principle.  If you are including the logic into the replication sprocs, besically you are manually merging it. However, you dont have to make the replication as "merge...

I dont see a need for that.