Looks like you have multiple triggers in the same table!

If that is the case you should either consolidate the logic into one! That way you are granted synchronous execution or make...

• Education is what may help you reach the extra mile.
• Training is what keeps you current.

They are both necessary if you want to really go far in your career. The...

It is kind of hard to give you an explanation without further data but I can tell you this. Every time you perform a DML you have to immediately check...

 >> I was trying to be a bit adventurous achieving it in the one trigger wasn't I  <<

Not really. You can determine the operetaion mode in the trigger with:

declare @cntI...

if by any chance you are checking that on QA, can you make sure that on Tools->Options->Results tab you have the "maximum column length" set to 8000

you should NEVER use trucate_only unless you are sure that you can take a FULL db backup like expressed above after the truncate you can pretty much throw away all...

varchar can accept up to 8000 chars

declare @data varchar(8000)

select @data = replicate('*',8000)

select len(@data)

and if you try:

declare @data varchar(8001) -- read the error message...

Good for you!!! .

Do you work for a company or are you freelance ?

CE = Cool Engine

is the smallest foot print for MS mobile applications

David,

Can you post the code of the entire procedure so that I can understand what are you trying to accomplish?

Allow me to throw in a small comment but a BIG advice. Modularize the Code into those pieces create as many procedures as pieces or starting points you need. Then...

Carl,

Assuming that

• you have TCP/IP Enabled on your Sever Network utility
• your server is not Hidden -- as you mentioned above
• your sever  is binding to TCP/IP library  -- per your logs

You may...

decimal(38,37) the presicion you are setting is way too far for the number representation. You are telling SQL to use 37 out of 38 digits to represent values after the...

Oh, and if you need to double check that my select works try:

create table myTable (data varchar(20))

insert into myTable ( data ) values ( 'normal' )

insert into myTable ( data...

Remi,

Sorry for the delay -- I have to get some work done , you know

 A quick example is :

create table myTable (data varchar(20))

insert...