Just to add to the above..

The below would be the cursor I would have, then at then Begin is where I would want the data flow task to connect to...

answered my own question whilst typing that out!

SELECT (select SERVERPROPERTY ('ServerName') ) as [Connection String], [Database Name], [Recovery Model], [Compatibility Level], State, Owner

FROM ...

I have no idea what they are trying to do that was a requirement for a new project, I think they are slightly.. confused.

Unless I am missing something, bulk insert...

Wasn't aware of that, thanks.

Yes thats right so its easy to make a link, we dont need to look into the step of the job or anything. Each job begins...

Perry Whittle (7/30/2014)

---

SQLSteve (7/30/2014)

---

Trying to get my head around a scenario

I have 2, 2 node clusters

PROD1(cluster 1) Clustered SQL instance1

PROD2(cluster 1)

DR 1 (cluster 2) Clustered SQL insatace 2

DR 2 (cluster...

Thanks for your help - this resolved the issue!

Thanks -

2 excels attached. As is is how it stands now (obviously sensitive data removed)

We just need each supplier code to have 1 entry, not multiple.

All of the...

Yes please,

Cheers for your help with this.

I need to count the number of times the supplier name is used but only display each supplier name once.

I am not sure what else we have to do...

The aim of this is to show which suppliers (along with the other fields selects) have been used in the last year.

So it is basically all supplier information which should...

Sean, the query only posted 1 entry back to me from the duplicate. Chris' posted both enrties, so I can now see all of the entries rather than just 1...

Chris M that is exactly what I was after! Thank you

Thats what I thought - Cheers

Eirikur Eiriksson (5/7/2014)

---

If I remember correctly, you'll have an upgrade grace period, you could install a new instance on the/a box, run the two in parallel for that period while...

Sean Lange (4/29/2014)

---

SQLSteve (4/29/2014)

---

What is everyones view on accessing SQL data which is stored on SQL instances in the DMZ via management tools on your local desktop?

Would you put a...