List of good books:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=151063

Unfortunately, in middle of crisis so can't help for the other...  Except why not write an INSERT statement using same syntax as MySQL??

.RANGE expects (CELL1, CELL2)....  Have you tried .CELLS("A2") ???

Is MSDTC running on VSQL6???

Another way would be to run "sp_who2 active" and then you could run DBCC INPUTBUFFER(SPID # here) to see the transactions....

I know you can output the 1st one to a...

Can you please post what you have done so we can assist you (instead of us providing all the work and no credit)????

actually I was just thinking "Hey, let's see if the balloon flies.... THUD", hmm lead not good to make balloon out of CHECK....

Seriously, I just threw the IDEA of a...

For your project table why not have a PROJECT table and a TASK table.  This way WHEN the PROJECT moves through the various PHASES you could have an UPDATE/INSERT trigger...

You can either FORCE the index WITH(INDEX(PK_HERE)), change the datatype in your table, OR may need to perform INDEX maintenance and everything may go back to normal.

# of rows has...

I use..

Inside SQL Server 2000 (MS Press)

Mastering SQL Server (Sybex)

SQL Server 2000 The Complete Reference (Database Professional's Library)

Each of these has a different and better feel/read on different subjects which...

Its no issue at all.  That is why we are here

A couple of different things could be causing this.

1.  NO primary key on one of the tables

2.  The UPDATE is attempting to UPDATE more than 1 table

thats all I have...

sysindexes is used strictly for a close enough row count for the indexes themselves.  It was not meant to be queried off of for row count.  You could possibly add...

1.  Don't know but, don't think it pertains in this case.

2.  For SQL 2K you would run sp_change_users_login with auto_fix BOL has information or you can find it on-line probably...

Another thing to consider is WHEN you are doing the 1mm deletes....  IF you are doing it during the timeframe when users are in the system it will slowdown your...

Antares I agree 100% with what you say about sloppy code.  I just find it easier and more efficient for smaller apps to use the open/hold/close for the connection.  I...