Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Text Column

Author  Topic 

sujosh
Yak Posting Veteran

55 Posts

Posted - 2002-01-30 : 15:32:47
Dosent the inserted and deleted tables support text column? If it does not Is there a way I can get the old and new value of a text column in a table?

Thanks

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-30 : 15:58:20
If you are on SQL 2000 use INSTEAD OF Triggers


-Chad

Go to Top of Page

DavidD
Yak Posting Veteran

73 Posts

Posted - 2002-01-30 : 21:23:14
Can you change the column to a varchar? You'll have no problem then.

Go to Top of Page

sujosh
Yak Posting Veteran

55 Posts

Posted - 2002-02-01 : 12:13:15
Thanks Chad! I really appreciate it.

David:Unfortunately I cant change it

Thanks

Go to Top of Page
   

- Advertisement -