try:

exec xp_cmdshell 'telnet aukebper.dc-dublin.de 1521'

Can you post the DDL for the table, the query you are running, and some sample data?

DECLARE

@myTable TABLE

(

DataDate

DATETIME,

DataVale

INT

)

INSERT

@myTable

SELECT

Slightly confused by your requirements based on the data.  For September you are asking for data from July?  Date entered is 9-12-2007, data returned is for 7-1-2007 - 7-31-2007?

gova, so that's why i had trouble using STUFF when I was trying to come up with a conversion solution.  Thanks!

When trying to convert the character value '30122006', sql is expecting the value to represented in the format yyyymmdd.  I tried your sample and got the same error.  adding the...

Works fine for me also.

If I understand the licensing properly, you will need to purchase SQL Server using per procosser licensing.  Use of multiplexing does not reduce the requirements, you have to base it...

The above mentioned KB was very helpful in identifying my data issues and helping me correct them.

I already found a KB articule that should help me, thanks.

KB: http://support.microsoft.com/kb/923247

You indicate that the insert trigger works, how about the others?  If all is fine, I think you have successfully done what you set out to do.

Have you tested these triggers in a development environment?

The next question, is there a possibility of more than one record being inserted/updated/deleted at a time from the application?

Would you please provide the complete DDL for the trigger?

So, you are asking us on this forum to write your triggers for you instead of writing them yourself?  I'd like to see what you have tried to come up...

Going off-line, check your private messages.