November 27, 2007 at 4:34 am
I am trying to create an after update trigger which uses deleted table.
The problem is the table on which trigger is being created contains an image column.
Due to this i get the error:
Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.
It seems Microsoft has no plans to continue with the image data type and it recommends using data types other than image.
Can some one tell me what data type should i use here?
Is there any way i can create the trigger without modifying the column data type?
November 27, 2007 at 5:18 am
use Books Online !!!
it states :
Important:
ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead. For more information, see Using Large-Value Data Types.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply