Geoff.Sturdy (12/29/2016)

---

Its odd that Steve considers Brexit and the 2016 presidential election result as representing one of the "craziest" years of his life - we in the UK voted to...

Does this work for you?

If RecordCount > 0 Then

DTS.TaskResult = Dts.Results.Failure

You should be able to do this, but it's possible that you are using some features or expecting something in the destination currently that doesn't work (or is changed) in...

Are these both writeable? Meaning can data change on both sides? There isn't a good way to sync these if both can change. Merge replication works, but it's cumbersome -...

I hope it ends soon.

🙁

that's a better choice. Putting functions in the WHERE clause means all rows need to be evaluated, which is a scan of the heap or index.

Also note there are lots of scripts on this site that people have shared to do this: http://www.sqlservercentral.com/search/?q=copy+backup+files&t=s&sort=relevance

Please post new questions in a new thread in the future.

In this case, you would have to perform some more debugging. One common cause is that the account running xp_cmdshell...

I hate in place upgrades. They are asking for problems if there is an issue, and that could happen. If you must, then you need to go to sP2.

I much...

Not as much fun though. Plus, Grant maybe learned from me. He doesn't drive enough to make it worthwhile.

Congrats, Ray. You win.

I'll sort prizes this week. I'm thinking

1st - $100

2nd - $50

3rd - $200

Sound good?

Apologies for the delay. I agree the wording was sloppy and misleading. The parens are not required, and I've noted that in the answers.

Points awarded back

1. Yes, you need git installed. You can install any version. I've used TFS Git, but installed from the open source git repo[/url].

2. Any path will work. This just needs...

Well, for me, it was just getting away. Family vacation in Ireland for a week, walking, renting a car, enjoying another country with little computer time. My wife and I...

Good advice above. I would recommend either Ola's scripts or the Minion scripts[/url].