Manie Verster (6/1/2012)

---

anthony.green (6/1/2012)

---

I might be wrong, but I thought that option was for SQL Mail and not DB Mail so therefore shouldn't be in 2012 as SQL Mail is...

good link for SSMS keyboard shortcuts http://www.simple-talk.com/sql/sql-training/ssms-the-query-window-keyboard-shortcuts/

Andy Hyslop (6/1/2012)

---

Have a good one 🙂

Think...

Burger King

I shall say this now before I forget, happy 4 day weekend to all in the UK, time to drink copious amounts of alcohol.

F6 will cycle through the query panel, results panel, messages panel if thats what you want.

I might be wrong, but I thought that option was for SQL Mail and not DB Mail so therefore shouldn't be in 2012 as SQL Mail is depreciated.

There where exceptions...

Cheesy

For reference, adding the drive as a dependency didn't require SQL to be restarted before showing the drive, all done online with no issues.

Thanks Perry, I think it will be a try it and find out job. Trying to not restart the instance if I can, as we are a 24/7 operation...

I know LiteSpeed from Quest has object level restoration, not used that functionality myself so cannot confirm on how to use it, but it is in there.

Red-Gate have virtual restore,...

richardmgreen1 (6/1/2012)

---

Anthony - thanks for that, I'll give it a try and see what happens.

Just one quick question, why have you ignored master, model, msdb and tempdb in your code?

John...

I thought it would be blocked here to as its alcohol related, but must...

Koen Verbeeck (6/1/2012)

---

anthony.green (6/1/2012)

---

Koen Verbeeck (6/1/2012)

---

I would give my...

Koen Verbeeck (6/1/2012)

---

I would give my left kidney to...