][SQL Server]Cannot sort a row of size

Cannot sort a row of size 8155, which is greater than the
allowable maximum of 8094.][SQL Server 7.0]
Does anybody known how to fix this'"Jorge Balzo" <jbalzo@.eclac.cl> wrote:
> Cannot sort a row of size 8155, which is greater than the
> allowable maximum of 8094.][SQL Server 7.0]
> Does anybody known how to fix this'
--
Hi Jorge,
You have reached the maximum row size allowed in a select statement. You
need to either modify your view or table to include varchar() columns or
remove some of the columns so that the total datalength of the data row
doesn't exceed 8094 bytes that requires sorting.
Hope this helps,
--
Eric Cárdenas
SQL Server support|||You could try the ROBUST PLAN optimizer hint. I'm not sure whether it will help in your particular
situation, though.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jorge Balzo" <jbalzo@.eclac.cl> wrote in message news:022601c3b9e1$ed8c7050$a501280a@.phx.gbl...
> Cannot sort a row of size 8155, which is greater than the
> allowable maximum of 8094.][SQL Server 7.0]
> Does anybody known how to fix this'
>

[ODBC SQL Server Driver] Timeout Expired - How to fix

I am running SQL (Selects and Deletes) against a large
table in a database and am getting Timeout Expired. I am
using Enterprise Manager (Right Click on Table and select
Query). Is there a setting that I need to change to allow
a long running query? It works fine in the SQL Query
Analyzer.
SELECT COUNT(*) AS Expr1
FROM CallDetailThe timeout is a property of the connection to the server. Select your
instance in the Enterprise manager, select properties. Then on the
connection tab change the timeout. (Zero means infinite)
Bruce
"Michael Orechoff" <anonymous@.discussions.microsoft.com> wrote in message
news:0ee701c39d6b$f0e86750$a401280a@.phx.gbl...
> I am running SQL (Selects and Deletes) against a large
> table in a database and am getting Timeout Expired. I am
> using Enterprise Manager (Right Click on Table and select
> Query). Is there a setting that I need to change to allow
> a long running query? It works fine in the SQL Query
> Analyzer.
> SELECT COUNT(*) AS Expr1
> FROM CallDetail|||Better indexing / design so that the query doesn't take so long? Use Query
Analyzer rather than Enterprise Manager (see http://www.aspfaq.com/2455)?
You could kludge it up by increasing your timeouts, but this is like
bandaging a fever.
"Michael Orechoff" <anonymous@.discussions.microsoft.com> wrote in message
news:0ee701c39d6b$f0e86750$a401280a@.phx.gbl...
> I am running SQL (Selects and Deletes) against a large
> table in a database and am getting Timeout Expired. I am
> using Enterprise Manager (Right Click on Table and select
> Query). Is there a setting that I need to change to allow
> a long running query? It works fine in the SQL Query
> Analyzer.
> SELECT COUNT(*) AS Expr1
> FROM CallDetail

@@SERVERNAME returns NULL

When I do:
SELECT @.@.SERVERNAME
It returns NULL. How, and how can I fix.
Thanks.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
Darin,
use:
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)