sql server programming: Sir,
I have created a stored procedure in which a variable @statement is declared of varchar type and size is 5000 ,I have assigned a long query to that variable with about 2000 characters, it worked fine in SQLserver7.0 but creating probs in SQLserver2000 gives error Max length is 128 characters.

What is the exact code and the exact error message? Which tool are you using
to execute the statement?

--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.

[quoted text, click to view]
is declared of varchar type and size is 5000 ,I have assigned a long query
to that variable with about 2000 characters, it worked fine in SQLserver7.0
but creating probs in SQLserver2000 gives error Max length is 128
characters.
[quoted text, click to view]

I got the solution i just made SET QUOTED_IDENTIFER OFF which was onn by
default in SQLserver 2000
Thankx


*** Sent via Developersdex http://www.developersdex.com ***