General discussion

Locked

Unable to see full conatins of column in Query Analyser of SQL 2000

By prashantdeshmukh ·
I am having a table with column of data type varchar 8000 which contains script for store procedure.
When I check it's contains from Enterprise Manager-> Tables ->Return All rows it displays contains as
"CREATE PROCEDURE [ExecutePayload] @RolloutSequence int
AS DECLARE @sourceserver varchar(128), @workstring varchar(8000)
EXECUTE [Administration].[dbo].[FindSourceServer] ' ', @sourceserver OUTPUT
IF (@RolloutSequence IS NULL)
BEGIN SET @RolloutSequence = 0 END
DECLARE epc CURSOR FOR SELECT Payload_String FROM Payload ORDER BY Sequence
OPEN epc
FETCH NEXT FROM epc INTO @workstring
WHILE (@@FETCH_STATUS = 0)
BEGIN
EXECUTE (@workstring)
FETCH NEXT FROM epc INTO @workstring
END
CLOSE epc
DEALLOCATE epc
INSERT INTO PayloadAudit (Sequence, Payload_String, DeploymentDate, RolloutSequence)
SELECT Sequence, Payload_String, GETDATE(), @RolloutSequence FROM Payload
TRUNCATE TABLE Payload"
=================================
But when I check contains in Qurey Analyser it displays ONLY till
"CREATE PROCEDURE [ExecutePayload] @RolloutSequence int
AS DECLARE @sourceserver varchar(128), @workstring varchar(8000)
EXECUTE [Administration].[dbo].[FindSourceServer] ' ', @sourceserver OUTPUT
IF (@RolloutSequence IS NULL)
BEGIN SET @RolloutS"
=================================

CAN ANY ONE HELP IN DISPLAYING FULL CONTAINS?????????????

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

See full contents

by etruss In reply to Unable to see full conati ...

I believe the problem is that the default column width in Query Analyzer is only 256 or so characters. You must go to the settings in Query Analyzer and increase the column width. I don't recall exactly where to find this setting but if you look around, you should be able to find it.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums