mdv3441 (12/8/2010)

---

I attempted to use this trigger but receive 2 errors and not sure why it is complaining (SQL Server 2005).

Msg 2715, Level 16, State 3, Procedure TRG_Profile, Line 1

Column,...

quetzco (11/22/2009)

---

Very, Very useful.

How can I avoid the problem of 'ntext', 'text', 'image' fields when executing:

IF @ACT = 'INSERT' INSERT [DBO].[AUDIT_BTPRJ_COSTIIMP] SELECT *,'INSERT' ,GETDATE() FROM INSERTED

IF @ACT = 'DELETE' INSERT...

Thanks for everyone's comments.

Just to illustrate that the SQL Server behaviour is not necessarily obvious ...

With the test data I used above, the following SQL Server query results in 120...

It is the developer's responsibility to ensure that the correct value is used to update, and I can sympathize with your desire for an error message to keep unexpected multiple...

Hi Lynn, and thanks. Perhaps I wasn't clear about my purpose. I...

Try putting a detail group on the list and then a page break on the detail group. Group on the data that identifies a statement e.g. the client key or...

If you need to recover, it will be much easier if you have both databases AND also the encryption keys - you will loose all security information without the key backup.

What about using environment.newline() in the field expression?

Something like:  iif(<condition for line 1>, <line 1> + environment.newline()) + <line 2>

Is your Windows version 64-bit?

I had the same error message with a DTS package. It worked on 32-bit Windows and on 64-bit Windows when running manually, but when running as a job, or...