How can that possibly work with a local temp table (seriously asking)?

george sibbald (8/10/2011)

---

darn, I don't use application roles anywhere!

That...

sebastian.rodriguez 21698 (8/10/2011)

---

Hi! i have the same problem that SSC Eights!, but a little bigger... i had a Log file of 1 TB,

i tried every single step of every one...

Long shot but this might be it...

If not then we need to see the full errors and any other errors you might have in the logs.

http://www.sqlskills.com/BLOGS/PAUL/post/Database-snapshots-when-things-go-wrong.aspx

Why do you want / need to do that?

Are you sure you're not opening another vesion of VS?

I usually try going to the Sql Server menu and open bids from there.

P.S. The Restore gui can generate that whole restore script using the same tables.

I love having a 2nd option. My personal choice what to use the file names available...

Option 2 will never work, it has to return only 1 row. To concatenate you can do something like this, but I would personally just look + print or...

I'm not an expert by any means on waits, but you could find this very useful : http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc

I ran your code George but I was missing all the application roles. So I can't use it atm!

We can't see the image you posted. You can upload it as an attachement.

Back to the problem at hand. Unless you are very experience with index tuning I'd...

I don't know why but I feel it's important to remind everyone that dbo.table and table will generate 2 different plans.

IIRC, even DBO. and dbo. will also do 2 plans....

djt78 (8/10/2011)

---

Thanks for the reply, Any suggestion to ensure that the DB i'm restoring to i will have exclusive access to, there will be occasions when users have not logged...

Not on my first read. I'd want to protect SA as much...

The pdf link works but nothing downloads.