A quote from one of my earlier posts. So I agree...

oh yes I was aware of that, but just because you should not do something does not mean someone won't do it. 🙂

your faith in humanity is refreshing!

?

http://msdn.microsoft.com/en-us/library/ms188694(SQL.90).aspx

What I take from this is if all your databases have the same owner,and a requirement for database chaining comes up, enable it at the database level, not the server...

This isn't the thread I was thinking of but Brian raises the same point:

http://www.sqlservercentral.com/Forums/Topic418501-149-1.aspx

so, should cross database chaining be enabled, people could access objects in other databases without permission checks....

thanks Jeff, now I have to try and find the thread and I can't even remember what the original subject matter was! :ermm:

It was something around it being easier to...

Some third party apps require a particular ID be the dbo, so watch out for that.

Having the db owned by an ID that restored it is not in itself a...

Is the file set to autogrow? Is it full because the drive is full?

Do you have a reason to suspect parallelism is causing the high CPU? Expect to see a lot of waittype CXPACKET if parallelism is a problem

You would probably be better...

As I...

Edogg,

I can confirm the entry is removed following a log backup (Full backup does NOT remove it). So the theory it is required should the db be recovered sounds correct.

I...

ours comes to a halt with a little bit...

Interesting thanks. I'll back the database up (this is a sandpit environment), restore etc, see when the entry goes for me.

cheers

george

On the basis the outage needs to be minimised logshipping wins hands down.

No need to spend money on a third party tool, no need to spend money on plane tickets...

SQL 2005 and up memory settings are dynamic and do not need a recycle. Look up sp_configure in BOL to prove it to yourself.