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