I might be wrong, ( i left my inside sql server 2000 book at work ) but I think if that is you only nullable column it will actually add...

The lowest level of the clustered indexes in SQL Server are the data pages, so if you move the clustered index, you are in fact moving the data.

Is your sa password null or have you intentionally left it out of the connection string?

I won't rant about connecting using 'sa', especially from and ASP page, but...

Hi,

If you look in BOL under:

SQL Server Architecture

 Relational Database Engine Architecture

  Server Scalability

   The SQL Server 2000 Workload Governor

You will find a fairly good explanation of when the governor kicks in and...

Are you seeing any deadlocks, or is it just blocking?

Is this what you are looking for:

SELECT CH1.Name

     , CH1.Address

     , CH1.PhoneNumber

     , CH1.CallDate

     , datediff("D",CH1.CallDate,getdate()) DaysAgo

 FROM CallHistory  ch1

    , (SELECT CH2.Name, max(CH2.CallDate) CallDate

        FROM HostileCallers HC

           ,...

Is the requirement to have all databases exist within a single SQL2000 instance, or can you merely move all five instances to a single machine?

Just a couple of questions before I suggest anything.

Are the users required to log into your app and is their login state persisted in the database?  Do you have a...

While trying to manufacture a semophoric method for locking a stored procedure by implementing something like a procedure execution state table that is constantly updated, SQL 2000 has the perfect...

My only concern would be the use of the WITH RECOMPILE.  If this is really necessary I would suggest putting each of the the UPDATE statements into separate procedures and...

The problem is that your selects are using different access paths than the update uses and this will cause deadlocks in a system with significant usage.  If you do as...

Sakis,

You say that you end up with different results sets when using nine more FETCH NEXT's after the FETCH ABSOLUTE.  I assume this is due to the ORDER BY clauses not...

Well, if you do not want to implement a temp table or table variable, and you are not ordering by a unique index, I am not sure you can accomplish...

Assuming you have a primary key or a unique index on the partners table, the solution is quite simple and doesn't involve using a cursor.  If you order the query...

Actually the IF does reset @@error. If you've coded assuming it does not, you may want to revisit that sql.

The test :

raiserror('an error happened',16,1)

select @@error

result

------

Server: Msg 50000, Level 16,...