Not sure where you can download the personal edition

The enterprise evaluation edition (120 days) can be downloaded from:

http://www.microsoft.com/downloads/details.aspx?familyid=d20ba6e1-f44c-4781-a6bb-f60e02dc1335&displaylang=en

Upgrading evaluation to retail:

http://support.microsoft.com/kb/281574/

Hello,

I've currently 3 different stored procedures with the same generic layout

EXECUTE master.dbo.USP_BACKUP_DATABASE @DatabaseNaam='MYDB'

EXECUTE master.dbo.USP_BACKUP_DATABASE_DIFF @DatabaseNaam='MYDB'

EXECUTE master.dbo.USP_BACKUP_DATABASE_LOG @DatabaseNaam='MYDB'

Currently redesigning it for controlled restores.

Someone posted an artikel about custom logshipping about a...

Try to find out what causes the pagelatch

1) exclusive updates

2) cpu-resources

3) i/o resources

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/dw_perf_top10.mspx

What version of sql server 2000 are you using and what is its patch level (sp3, sp4, hotfixes)

Could there be a sql agent job running under his username?

Is there difference in hostnames?

depends on the blade

Things to consider:

Does the database has to share anything with other programs

Are the I/O capabilities sufficient (and not shared)?

Are the cpu(s) sufficient?

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