SSMS is decoupled from SQL. You need to install that separately.

Well, I'd want to know why, but the only way I know to do this (Easily) is use roles for all permissions and then remove permissions from a role.

If you...

A few things. First, I think you have a fairly well setup and thought through environment. Kudos.

Second, you're confusing DR with testing a bit. If you break your DR system...

Downloaded and desktop upgraded just fine. This desktop has now gone from CTP3 -> RC0 -> Rc1 -> RC2 -> Rc3 ->...

Not sure that's a lock. It's a login/use restriction, maybe technically a lock, but you haven't used any locking to process data there. Certainly a process dropping off allows another...

SQL Server takes locks as needed to process data, change objects, etc., to avoid glitches. As Gilamonster mentioned, there isn't a lock db or schema option I'm aware of.

Been around for awhile 😉

http://www.sqlservercentral.com/Forums/Group3738.aspx

OK, I found the issue. The editor stripped out some of the XML. Instead of seeing

(1, CAST('<customer id = "1200">Acme</customer>' AS XML))

the editor stripped this to:

(1, CAST('Acme'...

Closed now, I think that last entry won't count as today is RTM.

I'll get the official build later today and finish this contest off.

My apologies here. I must have mixed up some code with the explanation, or maybe hadn't finished this and somehow put it for publication. No idea what I was thinking.

I've...

yb751 (6/1/2016)

---

Christmas in June!!!

The purchase of some Red Gate tools finally got approved by my boss. 😀

Feels like I've been begging forever. I'm not trying to promote those...

Sean Lange (6/1/2016)

---

I have to admit that I have seen very little spam over the last several days. I am guessing that Steve and the team either got something else...

New sample db: https://github.com/Microsoft/sql-server-samples/blob/jodebrui/samples/databases/wide-world-importers/documentation/root.md

Merge and peer replication do not have people writing to the same database. There isn't consistency, nor is there guarantees the writes will remain. In both those systems, you write...

I wouldn't necessarily throw an error, but you certainly could. I would tend to have an output or return param to indicate something.

I know RAISERROR is deprecated, but I doubt...