ARGH!!!!!!!! Why does our Tester have access to test automation scripts on our Live Application Environment?! She just set off the out of hours, weekly BULK INSERT process; the one...

Considering that the OP stated that this'll be in a High Availablity Group, it might be worth noting there is a known issue with it on Linux. Not sure if...

Welcome to SSC.

For any of the users here to answer your question(s) we'll need some things from you. In this case, we need DDL and Samples Data. There's...

I certainly agree that, if you can, store things such as phone numbers in a separate table if you're going to be storing multiple of them. You might well have...

Whata have you tried so far?

What do you mean by results? Is that your expected results? We need your Sample Data and DDL to be able to show you how to achieve that. Like i...

If the servers are in a Workgroup, then the only way their going to be able to "talk" to each other is via a SQL Login. If they need to...