SQL Server does allow a stored procedure to have a text or ntext parameter.

CREATE PROCEDURE foo
 @t1 ntext
AS
 SELECT @t1

This stored procedure will compile and execute.

>> none of the DataEnum Values support Text

What is the enum that you speak of? <s>

-Mike