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

Simon Smith (12/4/2008)

---

If anyone can tidy everything up and work out why it the error message at the beginning references a database name that doesn`t exists then that would be...

Same with a table variable. Main difference is that...

The only way you can backup a single table is if that table is in a filegroup by itself. Then you can back up the filegroup.

You can backup at the...

and no [] inside the IF, because you're trying to do a string match there, not refer to the DB itself.

What's the code you're trying to run inside sp_MSforeachdb?

Full backups do not break the LSN chain.

Easy to demonstrate

Create database TestingLogs

Go

use TestingLogs

go

Create Table Test (id int)

insert into Test values (1)

go

backup database TestingLogs to disk = 'D:\Develop\TestingFull1.bak' -- full backup...

Three steps backwards....

When data is changed in SQL, the changes are made to the data pages in memory. The record of the change is then written to the transaction log...

Why?

I'll download the video later, watch it and see...

srawant (12/2/2008)

---

Hey Gail,

I have a same database in one of my pre-prod server which is currently dead. I can work on this server to fix the database. So, can you...