Both servers are SQL 2000?

how did you set that character to one server?

Remember that after instalation, sql let the SA password equal to null. Like they said, maybe you are loggin with mixed mode. Can you send the connection string?

Try:

Declare @Select Varchar(500)

Set @Select='Select c1, c2, c3 from t1'

Create Table #temp

(id int identity (1,1) not null,

c1,

c2,

c3)

Insert #temp

EXEC (@Select)

Select * from #Temp

Do you have any indexes? Are they table or views?

Did you try diskperf -YD from command line? You will need to reboot the system to enable it.

MAybe using the simple recovery model is not a good advice. More in a production db.

You should check why the log file is growing (with profiler maybe) and you could...

If you run the script in http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=473

you will se that it runs dbcc showcontig for all indexes and it also writes a log to a file with osql.

Rate...

What do you mean with the correct order?

With explicits transaction, you must finish the transaction with either commit or rollback. If you don't finish the transaction, then it will remain open. I don't have sql here but...

Do you have explicits transactions on?

How are you running the backups? Did you check the active transaction?

I think we need more info before we try to give you a solution

It does'n seems to be a SQL server problem. Anyting unusual in Exchange?

Why don't you specified in the aplication the lock_timeout setting. Remember that you must handle the error in the aplication.

In SQL 2000, you can delete in cascade. A trigger could be

Create Trigger T_Name

On Table_Name

For Delete

As

Delete OtherTableName

Where WhatEver= Whatever

You can change it. You will need to create more indexes, one...

Hi,

Did you run any DBCC command in the DB or table? If you don't, why don't you try DBCC CheckDB or DBCC CheckTable.

Tell me...