Robert L. Stewart
rl_stewart at highstream.net
Thu Jan 18 12:59:24 CST 2007
All, I am trying to get a text data field to update in SQL 2000 using a stored procedure. CREATE PROCEDURE [dbo].[sp_SQL_addUpdate] @SQLUpdate_By nvarchar(25), @SQLUpdate_DB nvarchar(15), @SQLUpdate_Object nvarchar(50), @SQLUpdate_Description varchar(8000), @SQLUpdate_Script text, @SQLUpdate_ID int OUT AS DECLARE @ptrval binary(16) INSERT INTO dbo.tblSQLUpdates( SQLUpdate_By, SQLUpdate_DB, SQLUpdate_Object, SQLUpdate_Description ) VALUES ( @SQLUpdate_By, @SQLUpdate_DB, @SQLUpdate_Object, @SQLUpdate_Description ) SELECT @SQLUpdate_ID = @@Identity SELECT @ptrval = TEXTPTR(SQLUpdate_Script) FROM dbo.tblSQLUpdates WHERE SQLUpdate_ID = @SQLUpdate_ID WRITETEXT tblSQLUpdates.SQLUpdate_ID @ptrval @SQLUpdate_Script When writing the text back, I am getting a truncated value. My guess is that it is around 8000 characters. Anyone have any insight into it? Thanks, Robert