BWFC (6/22/2016)

---

As to the Brexit...

I thought the most interesting comment on it all that I saw was that there's much more reason for the UK to have common cause with...

Lynn Pettis (6/22/2016)

---

A little more on INSTEAD OF triggers.

They can be declared on views. They can be used to make non-updateable views updateable because you can handle the updates...

I'm not sure where this appears in setup. Certainly it should be quite visible. I think that if you don't have this, setup fails on one of the checks.

If you query node 2 in the FROM clause, you still get values.

Acme1234 is returned.

SQLDoc can do some of this: http://www.red-gate.com/dynamic/products/sql-development/sql-doc/download

Disclosure: I work for Redgate Software.

To resolve the block? Nothing until it commits or rolls back. If you can post some code, maybe there's a way to shorten the transaction.

Statistics might help, or creating an...

chris 24158 (6/21/2016)

---

I'm confused. It appears you now advocate not upgrading if the SQL version is less than eight years old -- SQL2008R2? Forgive me, but I didn't...

I'll say that I'm up and down. Life gets busy at times, so I have to balance out the time I put towards charity.

My thought is that we all need...

I'll add another note for what Gail and Y.B. said.

Don't do this.

Create a role, your own role, and use the script to GRANT to the role. Then add the user...

Markus (6/20/2016)

---

I attended a Microsoft event about SQL 2016 and have read a lot of information about this new release. It does appear this is the best version yet....

Ivan Arjentinski (6/20/2016)

---

The dev effort is usually not simply for embracing the new features. Most of the dev effort is to keep our apps running and supporting both newer and...

roger.plowman (6/20/2016)

---

I would have thought the lack of a GO after the GRANT would have left permissions unchanged for the final SELECT. This is something I've run into with SQL...

Try fn_dblog

http://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

http://www.sqlskills.com/blogs/paul/using-fn_dblog-fn_dump_dblog-and-restoring-with-stopbeforemark-to-an-lsn/

For both, you'll need to provide code. I'm not sure why #1 wouldn't return something without more detail.

For #2, are you sure this fires? I'd add logging code to your...

I agree with Scott. Don't worry about this.