Are the database files full? That might allow deletes but not inserts.

I'm a semi-DIYer. Whether I do something or pay someone depends on a number of things, including whether or not I have the tools to do it. I...

A single column, either Int or Char, used as a bitmask, would probably be better than 26 bit fields. If you need to add another condition, you just add...

You can't pass a table variable, but you can pass an XML variable. Pretty easy to set up.

It could.

Alternately, are you doing any distributed transactions? If not, then the error doesn't matter.

I've always run SQL on a local admin account. What's the reason not to in this case?

You could have reporting services create the files and store them, then have a proc go through and e-mail each one with DBMail. That may not be the best...

26 bits will take 4 bytes of storage per row for the data. 26 ints will take 108 bytes of storage per row. That also means more IO,...

You can still end up with an infinite loop with this (well, it will loop till it hits the recursion limit).

Table1 has an FK that references Table3

Table2 has an FK...

Jeff Moden (7/9/2008)

---

GSquared (7/9/2008)

---

Jeff, I do the same thing.

Relational Theory is a wonderful thing, but every now and again (not more than ten or fifteen times per nanosecond), it runs...

Yeah, you add input parameters and Where clauses to it, obviously.

You're welcome.

Cool biz. Hope that gets you what you need. 🙂

You're welcome.