That was my first thought too. But schemabinding should prevent...

Good article. I'm just starting to play with 2008, and this definitely will help.

I'm assuming you mean anyone other than the OP, who is at least as confused as you are.

Since you already have the original table (the table the views select from), why not just use that as your source for the final table?

I recently did that by running a server-side trace for a month. There were several databases where the only connections to them were maintenance plans.

None that I know of.

Luke L (5/4/2009)

---

RBarryYoung (5/4/2009)

---

Uh,oh, copyright infringement, Warren's not gonna like that....

In your modules, create a module that can take the value as an input, a global variable that the module can assign the value to, and a function that can...

http://en.wikipedia.org/wiki/Werewolves_of_London

Take a look at the IsDate() function. If you select the rows where that = 0, for the column, you'll find the ones that won't work.

I'm having trouble following your question. Are you looking for something that does a running total? Like for inventory management?

Access denied usually means the login you are using for the link doesn't have access to the server you're linking to.

xp_fixeddrives can tell you how much space you have left on drives. I believe Red Gate's SQL Response can monitor things like sudden table/database growth.

There are ways to cook...

How do you determine which result to transfer, if there are multiple records with the same ID, but different data in other columns? (If the data is the same...

Steve Jones - Editor (5/4/2009)

---

GSquared (5/4/2009)

---

If someone were to mine SSC for this kind of thing, I'm going to guess that would determine that a fair number of people are...