I'll have to recheck it.

What edition of sql server 2000 is it? Standard,Enterprise,.. 32-bit or 64-bit

What edition of windows 2003 is it ? Standard,Enterprise,...

Your problem problably has been discussed on

http://sql-server-performance.com/Community/forums/p/24896/138597.aspx#138597

but...

insert into #ALLQ

select * --below will be treated as a "table"

from

(

SELECT 'T'+ T334.C2 + RIGHT(T334.C1,7) -- error message point to here

+ @TimeranH +@TimeranM +@TimeranS +@TimeranN,

@user1,C536870929, T.[RANK]

FROM ARSystem.dbo.T334 [T334],...

Hello,

You have to specify the format mask of the to_number function.

See

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm

At second thought, name the columns. Select column1,column... FROM OPENQUERY (... SELECT ... column1,....) in case the columnorder would...

Hello,

I would encapsulate the union to a table.

The issue is that the variable can only have one value, and sql server can't decide if the values comes from the second,......

Also check available memory and other applications running on the server.

Anything special in the logs? (sql, windows)

Try to run the stored procedure sp_who2 to find out which connections are actually running/sleeping/locked.

DBCC INPUTBUFFER (SPID) gives you the command text.

In addition you could start a sql trace with...

You can create an index on computed columns with certain connection settings. The index will store the computed values on disk.

Check "Creating Indexes on Computed Columns" in the books online

1) Have a backup of the existing udf's,stored procs

2)

You could create a script and execute it on the other server

Enterprise manger->rightclick database->generate sqlscript

->select the udf's/stored procedures

->choose your options (be careful...

It probably has to do something with the application roles:

Application roles bypass standard permissions.

When an application role is activated for a connection by the application, the connection permanently loses...

Have a look at

http://www.mcse.ms/message985011.html

Have you contacted Microsoft about the issue?

We had it very often but now at rare moments. Suspects: some backup/replication software keeping the filesystem too busy causing a short network timeout.

Changes made from often to rare:

Updated windows...

Sql server,most other databases and recently Vista keep data in cache (empty memory=wasted memory) to operate faster by avoiding disk access. Thats why its memory usage continues to grow (in...

Depending on frequency, you can create a linked server for it. The msaccess subforum probably holds the answer.

Dynamic queries good/bad : it depends.

Usually they give the same performance than stored procedures but lack some encapsulation. (since sql server will try to cache the plan)

For this goal, dynamic...

What is the serverpack level of win2000? Most recent windowsupdates installed?