Isn't 0 the successful return code in a C# process? In which case is it simply that because it gets that back, is simply doesn't look for anything else?

It...

Steve Jones - Editor (4/18/2009)

---

I agree with Gail and Alvin. You want to represent yourself well, and show what you know on your resume. I have talked to dozens of...

In order to accomplish what you're looking for you need to create a new empty table with the autonumber, then run an INSERT statement with the ORDER BY instruction attached....

keep in mind that as part of moving from one instance to the other, the SQL service was stopped and restarted. So - the error you got ultimately had...

Paul White (4/6/2009)

---

Without sarcasm tags or smileys, I'm not sure quite what to make...

Paul/Bob -

With you two posting minor articles for responses, there's no way to adequately quote anything. You pretty much covered the big topics. On the remaining topic...

steve - sounds to me that you need to get yourself nominated to sit on the ANSI SQL standards board. It is clear to me that you have a....

The error handling and the error catching in SQL 2005 can be tricky. Depending on the erro you might be facing, it may be "batch" or "thread" terminating, meaning...

Jack - I have to ask - are you talking about conceptual PK's?

I'm pretty sure you cannot have anything NULL in a primary key, at least not one...

JacekO (4/1/2009)

---

Not always it depends on ANSI_NULLS setting

This is from books online:

Care must be taken when comparing null values. The behavior of the comparison depends on the setting of the...

steve dassin (3/29/2009)

---

Matt Miller (3/27/2009)

---

I guess my first question would be - what DataPhor features can you not find elsewhere? The fact that ylou want this to run on...

I guess my first question would be - what DataPhor features can you not find elsewhere? The fact that ylou want this to run on top of a SQL...

Two other things to think about:

- CDATA is actually a reserved keyword in XML. You apparently have it capitalized a little different so it may not be interfering,...

Assuming you CAN write an inline table-valued function, then yes - it probably makes sense to do so. The reason it gets so much faster is that it gets...

with regards to any code-based connections (i.e. in apps your devs have built), simply switching to the Native client and setting the .Encrypted property of the connection Object to TRUE...