My backup procedure has the following structure

DECLARE @DatabaseName varchar(1000)

DECLARE @BackupLocation varchar(1000)

DECLARE @DayExtension varchar(1000)

/*adding day + time*/

SET @DayExtension =REPLACE(REPLACE(REPLACE(convert(varchar(30),CURRENT_TIMESTAMP,120),'-','_'),':','_'),' ','_')

SET @Backuplocation= '...defaultlocation...'

/*defaultlocation*/

SET @BackupLocation=@Backuplocation+'\'+@DatabaseName+'_'+@DayExtension +'_DIFF.BAK'

BACKUP DATABASE @DatabaseName

TO DISK = @BackupLocation

WITH INIT ,...

offtopic:

I recommend not to use the sa-account for software.

A. It is a well known superadministrator account.

Because of that:

*There exist alot of program's to crack passwords, having the account name helps.

*Sometimes...

infact when i m getting disconnected with client, i have to restart the client computer and the connection gets eshtablished again...........

That sounds fishy.

What method do you use when to connect...

Is this a intermittent error or always?

1)Check if the network connection is primestable

2)Check the integrity of your database. An integrity fault due corruption can cause an aborted connection.

More things to...

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