can you have multiple people called Jone in your tables? if so is the code the same in tableA and tableB for the right name?

SELECT

A.Code,

A.Name,

A.Sector,

B.Sector

FROM

tableA A

INNER JOIN

tableB B

ON

A.Code =...

2 connection managers, 1 for DEV, the other for UAT, then you need to use as many data flow tasks as you want to copy the tables from DEV to...

Take a look in my signature for the Cross Tabs links by Jeff, the second part is in relation to dynamic cross tabs.

what have you searched for so far, there are plenty good topics on the web on what you want

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