Without seeing the query, the table definition and the indexes (and preferably the execution plan, as a .sqlplan file), it's hard to offer any useful advice.

Raid 5 is not the best of ideas for transaction logs. Logs are write-heavy and raid 5 has the slowest write performance of any of the common raid levels.

If...

Just the admin DB. Unless there's a need to keep the proc in master?

You can't explicitly use the semi-joins. They're used by SQL when it processes an IN or an EXISTS. Both of those require that the contents be checked, but not joined,...

So you want it to appear on...

From the deadlock graph, you can see it occurred in the database with an id of 9 (that's why 9 was the first parameter to DBCC Page - DBCC PAGE(Database...

Meeting start date today, or meeting end date today?

Would this one fall into 18th feb or 19th feb?

Create a login for this purpose and give it rights on the objects needed. You can give it a very long, complex password, since it's not intended to ever be...

Use EXECUTE AS on the DDL trigger so that the trigger executes under the context of a login that has access to the admin DB and all objects involved. That...

nazaninahmady_sh (12/4/2008)

---

Thank you very much,

would you please help me to write a T_SQL block for transfering data from one table in one data base to another table in another data...

Please don't create new threads for existing problems. There have been lots of answers to your questions on the other thread you started on this.

Please continue discussion on the following...

Take a look at line 123 of the procedure abc_Activity_Inquire. There's an insert statement there that's one half of the deadlock.

The other half is a piece of dynamic sQL somewhere...

declare @test VARCHAR(20)

SET @test = 'resumé'

select @test

There's a difference between extended ASCII and unicode.

You've got MSDE there. (free, restricted version...

Why a trigger to move data from one database to another?

That trigger's got a cross join in it. You have no join between the inserted table and the main table....