Link should be fixed. Also here: http://events.doctorswithoutborders.org/index.cfm?fuseaction=donorDrive.personalCampaign&participantID=2216

You can use alerts (http://www.sqlservercentral.com/articles/alerts/89885/), though I'm not sure these are better than a job with a query in it. I think they'll both function similarly.

I am not sure if...

You have a few choices for copying specific tables.

1. Build an SSIS package to export those tables

2. Build a PoSh/bcp script to export those tables.

3. replicate those tables to a...

There's no switch for this in SQL Server. It's strictly administrative.

The only time this would come up is if you were audited. You'd just need to ensure you have the...

I tend to agree with Steve (sgmunson) here. Most of the responses are accurate, but annoying.

I agree this should be a setting in SSMS. Regardless of the technical aspects of...

Personally, I like the synonym approach since it's a layer of abstraction. If I needed to move to 3 tables, or implement partitioning, or anything else, I like having a...

Brandon J Williams (8/13/2014)

---

My point is that replication novices are quick to point the finger at replication when it's not replication that is the problem.

We actually haven't done much in...

Microsoft didn't do it that I can see. I've checked my US default 2008 and 2012 instances. Both of them have the objects at the same collation as the master...

Do you mean the service account password? Or your password for SQL Server?

The former needs to be done with Configuration Manager to ensure rights are maintained. Your password is like...

Robert.Sterbal (8/14/2014)

---

We have hundreds of thousands of you in the SQL Server community. ...

There are 1,742,404 logins on the site

is the ratio of logins to people closer to 10-1...

In case any of you missed it and want to ensure a picture gets posted to The Thread... http://www.sqlservercentral.com/articles/Editorial/114685/

Jason Shadonix (8/3/2014)

---

We use synonyms here and there, and have never had any issues with them "not working".

We use SPs over SQL code in our application whenever possible....

Bill Talada (8/1/2014)

---

Views might work for a small subset of DDL changes since views are rarely update-able when based on more than one table. How can you handle a...

I agree. You don't want to necessarily enable this by default.

That being said, I think you'd need to use dynamic SQL to build a script that would do this. I...

If someone is changing the encryption status, they're creating a lot of load to decrypt, and you'll create load to encrypt.

Don't automatically fix this. Catch it with monitoring (Check the...