Joan, it's not that complicated: you don't need to have two tables to be affected by this problem. For example, let's consider the following:

CREATE TABLE #tmp (
 ID int IDENTITY...

I think that an interesting article can be made of this, but which one of us wants to do it ? I may have some ideas to add regarding the...

Not using SET COUNT ON also affects ADO (maybe ADO.NET too, but I'm not familiar with it). For example, create a procedure similar to:

CREATE PROCEDURE SomeProc
AS
-- SET NOCOUNT ON
UPDATE...

Gary,

Using sp_executesql with an expression does not work. Here is a quote from BOL:

"stmt must be either a Unicode constant or a variable that can be implicitly converted to ntext....

Very interesting question ! I think it's the best QOD in the last 12 months. Indeed, the answer was wrong, but the question is so interesting that this doesn't matter to me...

It should work with multiple 4k strings, because Microsoft used it: look at the code of the sp_execresultset procedure in master. I guess that EXEC is trying to convert each string...

You can find a procedure that does crostabs dynamically at: http://www.johnmacintyre.ca/codespct.asp

Razvan

If there is chance that this table will be reffered by other tables, I would use the identity column as the primary key; if you are sure that you will...

JP, the HAVING clause has no effect in this query, because the estimateddate is part of the GROUP BY clause (and the MIN function is evaluated for each group and, of...

There are two KB articles regarding this issue:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q317852

http://support.microsoft.com/?kbid=827714

The first one suggests to install SP3 (which you installed already), the second suggests a post-SP3 hotfix (build 8.00.0857 or later)....

The TransID column will be an identity column only in the tblTranCommon table; in the tblTranAct table (and the other tables), TransID will be a normal (int) column. The application...

As I understand it, you want to have in the tblTranAct table only rows that have a corresponding row in tblTranCommon, i.e. it's not possible to have a tblTranAct row (or...

One of the following queries should give you the cause of the problem:

SELECT act.custaccno, COUNT(DISTINCT sr.salesperson)

FROM sales_report sr INNER JOIN activations act ON sr.dtvcustno = act.custaccno

WHERE...

I don't want to use "SET ANSI_WARNINGS OFF" because it is required to be ON to use indexes on computed columns or indexed views.

But I found a solution that is...

I think that they used -1 as this is the value for True in MS Access and in Visual Basic. Indeed, it seems that SQL Server 2000 behaves differently (more correct,...