db_cmptlevel to 70

db_cmptlevel to 70

Post by Syed » Wed, 29 Nov 2000 04:00:00



Setting db_cmptlevel to 70, in SQL server 7.0 database giving me following error
message:

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use text, ntext,
        or image columns in the 'inserted' and 'deleted' tables.

Is there any workaround of this where keeping Cmptlevel 7, still let me refer to
deleted & inserted table for text, ntext,images while using a update trigger in
the table.

Thanks

 
 
 

db_cmptlevel to 70

Post by Doo » Thu, 30 Nov 2000 04:00:00


No.

--
Doo
Senior Data Architect / DBA
PlanetJam Media Group


Setting db_cmptlevel to 70, in SQL server 7.0 database giving me following
error
message:

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use text, ntext,
or image columns in the 'inserted' and 'deleted' tables.

Is there any workaround of this where keeping Cmptlevel 7, still let me
refer to
deleted & inserted table for text, ntext,images while using a update trigger
in
the table.

Thanks