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?????????????