Max size of varchar variable in stored procedure 1

[coco86]

I have a stored procedure that contains a variable that is supposed to be varchar(1000). However, it insists on truncating the data I put into it at 255 chars...no error message, it just chops the end of the string off.

Is this a limitation of SQl Server and if it is is there any way to get around it? 255 is just not going to be enough.

-Coco

 

[SQLDenis]

it's not truncated...
query analyzer-->tools-->options-->results
change the 255 to a higher number

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[coco86]

Ok thanks it's showing up correctly in the results pane now.

I guess I have two different problems going on here because it still gets truncated when I pass it to the Persits Mailsender object (ASPemail) I guess there IS a limit for method calls.

Thanks for your help though.

-Coco