There's no really good way to do that because it's so difficult. A db could be referenced by a linked server or by a 3-part name contained in dynamic...

Yeah, you could do that, but it's rather bizarre. What would the day before's activities have to do with today?

Again, check this DMV:

sys.sql_expression_dependencies

A table that doesn't exist is a different issue, because SQL's deferred name resolution allows that, but not invalid/missing column names.

The other thing to try would be dmv:

sys.sql_expression_dependencies

Here's a quick cross-tab example specific to your situation:

SELECT D.PersonID,

MAX(CASE WHEN D.Activity = 'Woke Up' THEN D.ActivityTime END) AS WakeUpTime,

MAX(CASE WHEN D.Activity...

You didn't get an error because a bit column will treat any value greater than 1 as 1, so SQL converted the "2" to a 1.

Try running:

sp_refreshsqlmodule or

sp_refreshview

on potentially affected objects.

You should get errors on the object(s) that now reference unknown columns.

Jeff Moden (6/30/2015)

---

GilaMonster (6/30/2015)

---

Jeff Moden (6/30/2015)

---

It seems like a lot of folks don't understand that a non-clustered index is a duplication of data that not only affects queries and space...

You can add a file to tempdb if you need to. Or explicitly expand an existing file(s) yourself.

Be extremely careful if/when trying to modify, or drop, existing objects in...

Sean Lange (6/30/2015)

---

Jacob Wilkins (6/30/2015)

---

This is all rather interesting, so I thought I'd chime in.

Based on what I've tested, Scott is technically correct. Under the right conditions, even where it...

You'll probably need to use ROW_NUMBER() for now:

;WITH CTE_sales AS (

SELECT

date_created, sales,

...

Jeff Moden (6/26/2015)

---

ScottPletcher (6/26/2015)

---

Sean Lange (6/26/2015)

---

Scott you have been...

Sean Lange (6/26/2015)

---

Scott you have been around sql long...

Jeff Moden (6/25/2015)

---

ScottPletcher (6/25/2015)

---

sgmunson (6/25/2015)

---

ScottPletcher (6/25/2015)

---

Why does everyone keep repeating that? Of course NOLOCK hints...

sgmunson (6/25/2015)

---

ScottPletcher (6/25/2015)

---

Why does everyone keep repeating that? Of course NOLOCK hints make queries run...