Bother. At least I have them running separately through the Job Agent rather than calling each other so I'll only have to change them in one place. Thanks...

Out of curiosity, does specifying the 3-part name for a stored procedure (e.g. srienstr.dbo.sp_diabetes) prevent the check of master for procedures with a prefix of 'sp_'?

Not that I've been foolish...

Mike Byrd (3/4/2008)

---

There are times when an index is not needed for a foreign key. If the table is small (low number of rows) or the index column has...

Which version of SQL Server is this written for? I've got 2000, and neither the table names nor column names match the system tables.

GSquared (1/31/2008)

---

The only IT-specific definition of "valid" that I can find in any dictionary online is "A data-flow computer language", in which it is a proper noun.

If we're dealing with...

GSquared (1/31/2008)

---

I disagree with the point about the transactions.

Dictionary definition of "valid": "well based or logical" (Compact Oxford English Dictionary, as referenced on http://www.onelook.com).

Doing a transaction and rollback...

I chose the index one, and was also partly right. I too...