Cannot sort a row of size 8312, which is greater t

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Cannot sort a row of size 8312, which is greater t

Author

Topic

hanumanth
Starting Member

21 Posts

Posted - 2008-07-25 : 03:26:39

Cannot sort a row of size 8312, which is greater than the allowable maximum of 8094.

the above mentioned error was encountering while executing the Sp. plz give ur comments on this.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-25 : 04:10:49

whats the datatype of field used?

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2008-07-25 : 04:16:43

Covered in many places...

On these forums here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58825

If you've got rows containing a big NVARCHAR or a TEXT field and you are indexing / ordering these then it will not work. (or anything with a DATALENGTH longer that the limit)

If you can, post your sp code and a sample dataset and state your expected end result and someone here will be able to help you.

-------------
Charlie

hanumanth
Starting Member

21 Posts

Posted - 2008-07-25 : 04:17:00

openxml with explicit mode .. if selecting single row it is displaying properly .. if trying to fetch more than one row the above error was encountering .. wat may be the problem ..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-25 : 04:20:47

quote:
Originally posted by hanumanth

openxml with explicit mode .. if selecting single row it is displaying properly .. if trying to fetch more than one row the above error was encountering .. wat may be the problem ..

i was asking datatype. if you're not sure you can post code thats causing the error. i suspect its usage of some datatypes like ntext,text,.. which is causing this.

hanumanth
Starting Member

21 Posts

Posted - 2008-07-25 : 04:36:28

ALTER PROCEDURE [dbo].[KTM_GetTerminalProfile]
@doc ntext
AS
DECLARE @idoc int

DECLARE @ktmid nvarchar(10)
DECLARE @locid nvarchar(10)
DECLARE @ipadd nvarchar(15)
DECLARE @city nvarchar(15)
DECLARE @zip nvarchar(7)
DECLARE @status nvarchar(2)

--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc

select @ktmid = KTMID,@locid=LocationID,@ipadd=IPAddr,@city=City,@zip=Zip,@status=Status
from openxml (@idoc,'/Request/KTMProfile/Profile',2)
with (KTMID nvarchar(10),LocationID nvarchar(10),IPAddr nvarchar(15),
City nvarchar(15), Zip nvarchar(7),Status nvarchar(2))

SELECT 1 AS Tag, null AS parent,
ktm_locationlist.locname AS [Location!1!LocName!Element],
ktm_locationlist.locid AS [Location!1!LocID!Element],
null AS [KTM!2],
ktm_locationlist.locid AS [Profile!3!LocID!Element],
ktm_locationlist.locname AS [Profile!3!LocName!Element],
null AS [Profile!3!KTMID!Element],
null AS [Profile!3!CurrentState!Element],
null AS [Profile!3!CurrentStateDesc!Element],
null AS [Profile!3!GoState!Element],
null AS [Profile!3!IPAddr!Element],
null AS [Profile!3!Host!Element],
null AS [Profile!3!HttpPort!Element],
null AS [Profile!3!HeartBeatTimer!Element],
null AS [Profile!3!Name!Element],
null AS [Profile!3!Address!Element],
null AS [Profile!3!City!Element],
null AS [Profile!3!Zip!Element],
null AS [Profile!3!Status!Element],
null AS [Profile!3!StatusDesc!Element],
null AS [Profile!3!LastModifiedBy!Element],
null AS [Profile!3!LastModifiedDate!Element],
null AS [Services!4],
null AS [Service!5!ServiceID!Element],
null AS [Service!5!ServiceName!Element],
null AS [Service!5!ServiceIcon!Element],
null AS [Service!5!ServiceURL!Element],
null AS [Service!5!ServiceMainFSM!Element],
null AS [Service!5!IsAvailable!Element],
null AS [Devices!6],
null AS [Device!7!DeviceID!Element],
null AS [Device!7!DeviceName!Element],
null AS [Device!7!DeviceType!Element],
null AS [Device!7!TypeName!Element],
null AS [Device!7!IsAvailable!Element],
null AS [Settings!8],
null As [OtherConfig!9!WelcomeTitle!Element],
null As [OtherConfig!9!WelcomeText!Element],
null As [OtherConfig!9!WelcomeBanner!Element],
null As [OtherConfig!9!MainFSMURL!Element],
null As [OtherConfig!9!MaintenanceURL!Element],
null As [OtherConfig!9!KTMWPWSURL!Element]

from ktm_terminal
inner join ktm_locationlist on ktm_locationlist.Locid = ktm_terminal.Locid
left join KTM_ServicesOffered on KTM_ServicesOffered.KTMID = ktm_terminal.KTMID
left join KTM_Config on KTM_Config.KTMID = ktm_terminal.KTMID
left join ktm_servicemaster on KTM_ServicesOffered.ServiceID = ktm_servicemaster.serviceid
left join KTM_Devices on KTM_Devices.KTMID = ktm_terminal.KTMID
left outer join KTM_DevicesTypeSettings on KTM_DevicesTypeSettings.DeviceTypeID = KTM_Devices.DeviceType
where (@ktmid = '' or ktm_terminal.KTMID = @ktmid)
and (@status = '' or ktm_terminal.KTMStatus = @status)
and (@locid = '' or ktm_terminal.LocID = @locid)
and (@ipadd = '' or ktm_terminal.KTMIP = @ipadd)
and (@city = '' or ktm_terminal.KTMCity = @city)
and (@zip = '' or ktm_terminal.KTMZip = @zip)

union
SELECT 2 as tag,1 as parent,
ktm_locationlist.locname,
ktm_locationlist.locid,
'',
ktm_locationlist.locid,
ktm_locationlist.locname,
ktm_terminal.KTMID,
ktm_terminal.CurrentState,
case when ktm_terminal.CurrentState is null then '' else (select statedesc from ktm_StateMaster where StateCode = ktm_terminal.CurrentState) end,
ktm_terminal.GoState,
ktm_terminal.KTMIP,
ktm_terminal.KTMHostname,
ktm_terminal.HttpPort,
ktm_terminal.HeartBeatTimer,
ktm_terminal.KTMName,
ktm_terminal.KTMAddress,
ktm_terminal.KTMCity,
ktm_terminal.KTMZip,
ktm_terminal.KTMStatus,
case when ktm_terminal.KTMStatus is null then '' else (select StatusDesc from KTM_StatusMaster where StatusCode = ktm_terminal.KTMStatus) end,
ktm_terminal.ModifiedBy,
ktm_terminal.ModifiedDate,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
from ktm_terminal
inner join ktm_locationlist on ktm_locationlist.Locid = ktm_terminal.Locid
left join KTM_ServicesOffered on KTM_ServicesOffered.KTMID = ktm_terminal.KTMID
left join KTM_Config on KTM_Config.KTMID = ktm_terminal.KTMID
left join ktm_servicemaster on KTM_ServicesOffered.ServiceID = ktm_servicemaster.serviceid
left join KTM_Devices on KTM_Devices.KTMID = ktm_terminal.KTMID
left outer join KTM_DevicesTypeSettings on KTM_DevicesTypeSettings.DeviceTypeID = KTM_Devices.DeviceType
where (@ktmid = '' or ktm_terminal.KTMID = @ktmid)
and (@status = '' or ktm_terminal.KTMStatus = @status)
and (@locid = '' or ktm_terminal.LocID = @locid)
and (@ipadd = '' or ktm_terminal.KTMIP = @ipadd)
and (@city = '' or ktm_terminal.KTMCity = @city)
and (@zip = '' or ktm_terminal.KTMZip = @zip)

union
SELECT 3 as tag,2 as parent,
ktm_locationlist.locname,
ktm_locationlist.locid,
'',
ktm_locationlist.locid,
ktm_locationlist.locname,
ktm_terminal.KTMID,
ktm_terminal.CurrentState,
case when ktm_terminal.CurrentState is null then '' else (select statedesc from ktm_StateMaster where StateCode = ktm_terminal.CurrentState) end,
ktm_terminal.GoState,
ktm_terminal.KTMIP,
ktm_terminal.KTMHostname,
ktm_terminal.HttpPort,
ktm_terminal.HeartBeatTimer,
ktm_terminal.KTMName,
ktm_terminal.KTMAddress,
ktm_terminal.KTMCity,
ktm_terminal.KTMZip,
ktm_terminal.KTMStatus,
case when ktm_terminal.KTMStatus is null then '' else (select StatusDesc from KTM_StatusMaster where StatusCode = ktm_terminal.KTMStatus) end,
ktm_terminal.ModifiedBy,
ktm_terminal.ModifiedDate,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
from ktm_terminal
inner join ktm_locationlist on ktm_locationlist.Locid = ktm_terminal.Locid
left join KTM_ServicesOffered on KTM_ServicesOffered.KTMID = ktm_terminal.KTMID
left join KTM_Config on KTM_Config.KTMID = ktm_terminal.KTMID
left join ktm_servicemaster on KTM_ServicesOffered.ServiceID = ktm_servicemaster.serviceid
left join KTM_Devices on KTM_Devices.KTMID = ktm_terminal.KTMID
left outer join KTM_DevicesTypeSettings on KTM_DevicesTypeSettings.DeviceTypeID = KTM_Devices.DeviceType
where (@ktmid = '' or ktm_terminal.KTMID = @ktmid)
and (@status = '' or ktm_terminal.KTMStatus = @status)
and (@locid = '' or ktm_terminal.LocID = @locid)
and (@ipadd = '' or ktm_terminal.KTMIP = @ipadd)
and (@city = '' or ktm_terminal.KTMCity = @city)
and (@zip = '' or ktm_terminal.KTMZip = @zip)

union
SELECT 4 as tag,2 as parent,
ktm_locationlist.locname,
ktm_locationlist.locid,
'',
ktm_locationlist.locid,
ktm_locationlist.locname,
ktm_terminal.KTMID,
ktm_terminal.CurrentState,
ktm_terminal.CurrentState,
ktm_terminal.GoState,
ktm_terminal.KTMIP,
ktm_terminal.KTMHostname,
ktm_terminal.HttpPort,
ktm_terminal.HeartBeatTimer,
ktm_terminal.KTMName,
ktm_terminal.KTMAddress,
ktm_terminal.KTMCity,
ktm_terminal.KTMZip,
ktm_terminal.KTMStatus,
ktm_terminal.KTMStatus,
ktm_terminal.ModifiedBy,
ktm_terminal.ModifiedDate,
'',
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
from ktm_terminal
inner join ktm_locationlist on ktm_locationlist.Locid = ktm_terminal.Locid
left join KTM_ServicesOffered on KTM_ServicesOffered.KTMID = ktm_terminal.KTMID
left join KTM_Config on KTM_Config.KTMID = ktm_terminal.KTMID
left join ktm_servicemaster on KTM_ServicesOffered.ServiceID = ktm_servicemaster.serviceid
left join KTM_Devices on KTM_Devices.KTMID = ktm_terminal.KTMID
left outer join KTM_DevicesTypeSettings on KTM_DevicesTypeSettings.DeviceTypeID = KTM_Devices.DeviceType
where (@ktmid = '' or ktm_terminal.KTMID = @ktmid)
and (@status = '' or ktm_terminal.KTMStatus = @status)
and (@locid = '' or ktm_terminal.LocID = @locid)
and (@ipadd = '' or ktm_terminal.KTMIP = @ipadd)
and (@city = '' or ktm_terminal.KTMCity = @city)
and (@zip = '' or ktm_terminal.KTMZip = @zip)

union
SELECT 5 as tag,4 as parent,
ktm_locationlist.locname,
ktm_locationlist.locid,
'',
ktm_locationlist.locid,
ktm_locationlist.locname,
ktm_terminal.KTMID,
ktm_terminal.CurrentState,
ktm_terminal.CurrentState,
ktm_terminal.GoState,
ktm_terminal.KTMIP,
ktm_terminal.KTMHostname,
ktm_terminal.HttpPort,
ktm_terminal.HeartBeatTimer,
ktm_terminal.KTMName,
ktm_terminal.KTMAddress,
ktm_terminal.KTMCity,
ktm_terminal.KTMZip,
ktm_terminal.KTMStatus,
ktm_terminal.KTMStatus,
ktm_terminal.ModifiedBy,
ktm_terminal.ModifiedDate,
'',
KTM_ServicesOffered.ServiceID,
KTM_ServiceMaster.ServiceName,
KTM_ServiceMaster.ServiceIcon,
KTM_ServiceMaster.ServiceUrl,
KTM_ServiceMaster.ServiceMainFSM,
KTM_ServicesOffered.IsAvailable,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
from ktm_terminal
inner join ktm_locationlist on ktm_locationlist.Locid = ktm_terminal.Locid
left join KTM_ServicesOffered on KTM_ServicesOffered.KTMID = ktm_terminal.KTMID
left join KTM_Config on KTM_Config.KTMID = ktm_terminal.KTMID
left join ktm_servicemaster on KTM_ServicesOffered.ServiceID = ktm_servicemaster.serviceid
left join KTM_Devices on KTM_Devices.KTMID = ktm_terminal.KTMID
left outer join KTM_DevicesTypeSettings on KTM_DevicesTypeSettings.DeviceTypeID = KTM_Devices.DeviceType
where (@ktmid = '' or ktm_terminal.KTMID = @ktmid)
and (@status = '' or ktm_terminal.KTMStatus = @status)
and (@locid = '' or ktm_terminal.LocID = @locid)
and (@ipadd = '' or ktm_terminal.KTMIP = @ipadd)
and (@city = '' or ktm_terminal.KTMCity = @city)
and (@zip = '' or ktm_terminal.KTMZip = @zip)

union
SELECT 6 as tag,2 as parent,
ktm_locationlist.locname,
ktm_locationlist.locid,
'',
ktm_locationlist.locid,
ktm_locationlist.locname,
ktm_terminal.KTMID,
ktm_terminal.CurrentState,
ktm_terminal.CurrentState,
ktm_terminal.GoState,
ktm_terminal.KTMIP,
ktm_terminal.KTMHostname,
ktm_terminal.HttpPort,
ktm_terminal.HeartBeatTimer,
ktm_terminal.KTMName,
ktm_terminal.KTMAddress,
ktm_terminal.KTMCity,
ktm_terminal.KTMZip,
ktm_terminal.KTMStatus,
ktm_terminal.KTMStatus,
ktm_terminal.ModifiedBy,
ktm_terminal.ModifiedDate,
'',
null,
null,
null,
null,
null,
null,
'',
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
from ktm_terminal
inner join ktm_locationlist on ktm_locationlist.Locid = ktm_terminal.Locid
left join KTM_ServicesOffered on KTM_ServicesOffered.KTMID = ktm_terminal.KTMID
left join KTM_Config on KTM_Config.KTMID = ktm_terminal.KTMID
left join ktm_servicemaster on KTM_ServicesOffered.ServiceID = ktm_servicemaster.serviceid
left join KTM_Devices on KTM_Devices.KTMID = ktm_terminal.KTMID
left outer join KTM_DevicesTypeSettings on KTM_DevicesTypeSettings.DeviceTypeID = KTM_Devices.DeviceType
where (@ktmid = '' or ktm_terminal.KTMID = @ktmid)
and (@status = '' or ktm_terminal.KTMStatus = @status)
and (@locid = '' or ktm_terminal.LocID = @locid)
and (@ipadd = '' or ktm_terminal.KTMIP = @ipadd)
and (@city = '' or ktm_terminal.KTMCity = @city)
and (@zip = '' or ktm_terminal.KTMZip = @zip)
union
SELECT 7 as tag,6 as parent,
ktm_locationlist.locname,
ktm_locationlist.locid,
'',
ktm_locationlist.locid,
ktm_locationlist.locname,
ktm_terminal.KTMID,
ktm_terminal.CurrentState,
ktm_terminal.CurrentState,
ktm_terminal.GoState,
ktm_terminal.KTMIP,
ktm_terminal.KTMHostname,
ktm_terminal.HttpPort,
ktm_terminal.HeartBeatTimer,
ktm_terminal.KTMName,
ktm_terminal.KTMAddress,
ktm_terminal.KTMCity,
ktm_terminal.KTMZip,
ktm_terminal.KTMStatus,
ktm_terminal.KTMStatus,
ktm_terminal.ModifiedBy,
ktm_terminal.ModifiedDate,
'',
null,
null,
null,
null,
null,
null,
'',
KTM_Devices.DeviceID,
case when KTM_Devices.DeviceID is null then '' else (select DeviceName from KTM_DevicesMaster where KTM_DevicesMaster.DeviceID = KTM_Devices.DeviceID) end,
KTM_Devices.DeviceType,
case when KTM_Devices.DeviceType is null then '' else (select TypeName from KTM_DevicesType where KTM_DevicesType.TypeID = KTM_Devices.DeviceType) end,
KTM_Devices.IsAvailable,
'',
null,
null,
null,
null,
null,
null
from ktm_terminal
inner join ktm_locationlist on ktm_locationlist.Locid = ktm_terminal.Locid
left join KTM_ServicesOffered on KTM_ServicesOffered.KTMID = ktm_terminal.KTMID
left join KTM_Config on KTM_Config.KTMID = ktm_terminal.KTMID
left join ktm_servicemaster on KTM_ServicesOffered.ServiceID = ktm_servicemaster.serviceid
left join KTM_Devices on KTM_Devices.KTMID = ktm_terminal.KTMID
left outer join KTM_DevicesTypeSettings on KTM_DevicesTypeSettings.DeviceTypeID = KTM_Devices.DeviceType
where (@ktmid = '' or ktm_terminal.KTMID = @ktmid)
and (@status = '' or ktm_terminal.KTMStatus = @status)
and (@locid = '' or ktm_terminal.LocID = @locid)
and (@ipadd = '' or ktm_terminal.KTMIP = @ipadd)
and (@city = '' or ktm_terminal.KTMCity = @city)
and (@zip = '' or ktm_terminal.KTMZip = @zip)
union
SELECT 8 as tag, 7 as parent,
ktm_locationlist.locname,
ktm_locationlist.locid,
'',
ktm_locationlist.locid,
ktm_locationlist.locname,
ktm_terminal.KTMID,
ktm_terminal.CurrentState,
ktm_terminal.CurrentState,
ktm_terminal.GoState,
ktm_terminal.KTMIP,
ktm_terminal.KTMHostname,
ktm_terminal.HttpPort,
ktm_terminal.HeartBeatTimer,
ktm_terminal.KTMName,
ktm_terminal.KTMAddress,
ktm_terminal.KTMCity,
ktm_terminal.KTMZip,
ktm_terminal.KTMStatus,
ktm_terminal.KTMStatus,
ktm_terminal.ModifiedBy,
ktm_terminal.ModifiedDate,
'',
null,
null,
null,
null,
null,
null,
'',
KTM_Devices.DeviceID,
case when KTM_Devices.DeviceID is null then '' else (select DeviceName from KTM_DevicesMaster where KTM_DevicesMaster.DeviceID = KTM_Devices.DeviceID) end,
KTM_Devices.DeviceType,
case when KTM_Devices.DeviceType is null then '' else (select TypeName from KTM_DevicesType where KTM_DevicesType.TypeID = KTM_Devices.DeviceType) end,
KTM_Devices.IsAvailable,
(select [dbo].FN_GetSettingKeys (KTM_DevicesTypeSettings.DeviceID,KTM_DevicesTypeSettings.DeviceTypeID,@ktmid)),
null,
null,
null,
null,
null,
null
from ktm_terminal
inner join ktm_locationlist on ktm_locationlist.Locid = ktm_terminal.Locid
left join KTM_ServicesOffered on KTM_ServicesOffered.KTMID = ktm_terminal.KTMID
left join KTM_Config on KTM_Config.KTMID = ktm_terminal.KTMID
left join ktm_servicemaster on KTM_ServicesOffered.ServiceID = ktm_servicemaster.serviceid
left join KTM_Devices on KTM_Devices.KTMID = ktm_terminal.KTMID
left outer join KTM_DevicesTypeSettings on KTM_DevicesTypeSettings.DeviceTypeID = KTM_Devices.DeviceType
where (@ktmid = '' or ktm_terminal.KTMID = @ktmid)
and (@status = '' or ktm_terminal.KTMStatus = @status)
and (@locid = '' or ktm_terminal.LocID = @locid)
and (@ipadd = '' or ktm_terminal.KTMIP = @ipadd)
and (@city = '' or ktm_terminal.KTMCity = @city)
and (@zip = '' or ktm_terminal.KTMZip = @zip)
union
SELECT 9 as tag,2 as parent,
ktm_locationlist.locname,
ktm_locationlist.locid,
'',
ktm_locationlist.locid,
ktm_locationlist.locname,
ktm_terminal.KTMID,
ktm_terminal.CurrentState,
ktm_terminal.CurrentState,
ktm_terminal.GoState,
ktm_terminal.KTMIP,
ktm_terminal.KTMHostname,
ktm_terminal.HttpPort,
ktm_terminal.HeartBeatTimer,
ktm_terminal.KTMName,
ktm_terminal.KTMAddress,
ktm_terminal.KTMCity,
ktm_terminal.KTMZip,
ktm_terminal.KTMStatus,
ktm_terminal.KTMStatus,
ktm_terminal.ModifiedBy,
ktm_terminal.ModifiedDate,
'',
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
ktm_config.WelcomeTitle,
ktm_config.WelcomeText,
case when ktm_config.WelcomeBanner is null then '' else ktm_config.WelcomeBanner end,
ktm_config.MainFSMURL,
ktm_config.MaintenanceURL,
ktm_config.KTMWPWSURL
from ktm_terminal
inner join ktm_locationlist on ktm_locationlist.Locid = ktm_terminal.Locid
left join KTM_ServicesOffered on KTM_ServicesOffered.KTMID = ktm_terminal.KTMID
left join KTM_Config on KTM_Config.KTMID = ktm_terminal.KTMID
left join ktm_servicemaster on KTM_ServicesOffered.ServiceID = ktm_servicemaster.serviceid
left join KTM_Devices on KTM_Devices.KTMID = ktm_terminal.KTMID
left outer join KTM_DevicesTypeSettings on KTM_DevicesTypeSettings.DeviceTypeID = KTM_Devices.DeviceType
where (@ktmid = '' or ktm_terminal.KTMID = @ktmid)
and (@status = '' or ktm_terminal.KTMStatus = @status)
and (@locid = '' or ktm_terminal.LocID = @locid)
and (@ipadd = '' or ktm_terminal.KTMIP = @ipadd)
and (@city = '' or ktm_terminal.KTMCity = @city)
and (@zip = '' or ktm_terminal.KTMZip = @zip)
order by [Location!1!locid!Element],[KTM!2],[Profile!3!KTMID!Element],[Services!4],[Devices!6],[Device!7!DeviceID!Element],[Settings!8]
for xml explicit

EXEC sp_xml_removedocument @idoc

hanumanth
Starting Member

21 Posts

Posted - 2008-07-25 : 04:42:08

i pasted my SP code .. output should be in xml format .. plz do this

quote:
Originally posted by Transact Charlie

Covered in many places...

On these forums here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58825

If you've got rows containing a big NVARCHAR or a TEXT field and you are indexing / ordering these then it will not work. (or anything with a DATALENGTH longer that the limit)

If you can, post your sp code and a sample dataset and state your expected end result and someone here will be able to help you.

-------------
Charlie

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-25 : 07:12:37

quote:
Originally posted by hanumanth

i pasted my SP code .. output should be in xml format .. plz do this

quote:
Originally posted by Transact Charlie

Covered in many places...

On these forums here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58825

If you've got rows containing a big NVARCHAR or a TEXT field and you are indexing / ordering these then it will not work. (or anything with a DATALENGTH longer that the limit)

If you can, post your sp code and a sample dataset and state your expected end result and someone here will be able to help you.

-------------
Charlie

which is part that errors?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources