Just guess:

do you actually use something like  PRINT ... + CAST(... as varchar(10)) ?

can you post your CAST statement?

Yes, it's possible using OUTPUT parameters.

See BOL how to use parameters with sp_executesql and how to declare and use OUTPUT paramenters.

It's about size of joined rows.

Len(text)*2 + len(name)*2 + other fixed sizes must be < 8095

You can identify problermatic objects with this query:

select O.Name, S.Text, LEN(S.Text), len(O.Name) + LEN(S.Text)

from...

I've got the same error when I ran this query against master db!

I modified script a little and error has gone:

select O.name , SumLen

from sysobjects O

INNER...

sysobjects O

inner join syscomments S on O.ID = S.ID

Group by O.name

Order by Sum(Len(S.Text)) Desc 

  |--Sort(ORDER BY:...

My SQL Server is SP4.

And everything works perferct.

I have SP with size 104kb. And I can see it in the resultset.

I don't know how collation may affect this query because there...

But it works!

Any of these scripts does not fail on any of servers I can access.

Try to find out what's wrong with your server.

Do some test exersises like this:

SELECT MAX(LEN(TEXT))...

TEXT column in syscomments has type NVARCHAR(4000).

It cannot be too long.

I've used copy-paste into my QA for the first suggestion - it works without any problem.

SQL Server 2000 SP4.

What's wrong with your SQL Server?

# tables exist until connection is ended or you explicitely drop it.

If you run it from QA it will stay there until you close the window or execute

DROP #Foo.

If...

DECLARE @linkedServerName VARCHAR(255)

SET @linkedServerName = 'ProductionLinkedServerName'

GO -- What this thing is doing here???

EXEC('CREATE PROCEDURE whatever

AS

BEGIN

    SELECT * FROM ['+@linkedServerName+']. ...

END

GO')

And...

Result from my computer:

RIGHTHAND                 Position_SpaceSpaceHAND Position_SpaceHAND

------------------------- ----------------------- ------------------

RIGHT HAND with one space 0                       6

(1 row(s) affected)

RIGHTHAND                  Position_SpaceSpaceHAND Position_SpaceHAND

-------------------------- ----------------------- ------------------

RIGHT HAND with two spaces 6                       7

(1...

Did you bother to open BOL on topic "IDENTITY (property)"?

BTW, table UDF is a View with parameter.

If you want to have a VIEW dependable on any parameter you don't need to inbiuld table UDF in this VIEW, you need...