I would say it's a security hole since most people worry less about UDP and this may be an open port on lots of firewalls to allow SQL instance discovery....

You have a disparate list of things here. Killing processes is process admin. To look at logins, security admin does this, but also allows creating them. I suspect you'd...

Your example is a bit confusing, since you are showing different paid amounts. I'm guessing this means these are two separate examples, and not intended to relate to each other....

That would...

Probably

Thanks, fixed.

Prizes sent. Let me know if you get them. I assume Yahoo sends a trophy?

New thread for 2017 - http://www.sqlservercentral.com/Forums/Topic1846421-61-1.aspx

chrisn-585491 (12/29/2016)

---

On the flip side there's even more great open data sets to build analysis skills on. Everything from census to the stars, if you want some real data to...

chrisn-585491 (12/29/2016)

---

Microsoft has stumbled some, but has made some great steps with SQL Server, .NET and even cool cross platform tools like VS Code. I'm really enjoying F# and think...

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.