Why temp table Inserted is not visible outside trigger? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Why temp table Inserted is not visible outside trigger?

Message

From

11/09/2006 13:30:35

Marc Levesque
La Prairie, Quebec, Canada

To

11/09/2006 13:27:35

Naomi Nosonovsky
Wisconsin, United States

General information

Forum:

Microsoft SQL Server

Category:

Other

Title:

Re: Why temp table Inserted is not visible outside trigger?

Environment versions

SQL Server:

SQL Server 2000

Miscellaneous

Thread ID:

01152798

Message ID:

01152809

Views:

28

If I try this...

INSERT INTO MyTable_tmp SELECT * FROM Inserted

I got the following error... (on the check syntax)
Error 311: Cannot use text, ntext or image columns in the 'Inserted' and 'Deleted' tables.

Marc Levesque
La Prairie, Quebec (CANADA)
marc.levesque@videotron.ca

Click here to load this message in the networking platform