I'm suprised that Jeff Moden hasn't jumped all over this. 😉

Anyway, I think what needs to be considered is that while doing it row by row may only lock...

If you already have the SQL Server table setup with an IDENTITY column, and the non-conforming material number from the spreadsheet is just an integer value that you want to...

Statspack is a pretty comprehensive report with alot of parts to it. Some of the statistics you can get using the Performance Monitor in the Administrative Tools of Control...

When the transaction log backup happens, it frees up space within the file to be reused by other transactions. If what you say is true, then to keep shrinking...

What tool or program are you using to log into SQL Server? Do you have aliases setup on the client computer in SQL Server Configuration Manager?

Bob Bridges (9/19/2008)

---

On SQL Server 2000...

They currently do a full backup every night and have a job that backs up the transaction log every 2 hours.

...

The current recovery model is...

Is the Access application using pass through queries? If not, Access has a bad habit of trying to grab the whole table and perform the query in its own...

If the new file is in the same filegroup, SQL Server will automatically split new extents written across both files. If you only want it to write to the...

In SQL Server, when performing large transactions on a given table, the engine can decide that it's more efficient to grab a few page locks than many row locks. ...

It looks like your best bet is going to be having a subquery which assigns an "order" to the CODE column somehow, like using:

SELECT enc_id,

MAX(CASE WHEN...

The SQL Server 2000 books online says that you can do a client install on Windows 98 machine. As for the MDAC, version 2.8 is supported on Windows 98:

http://www.microsoft.com/downloads/details.aspx?familyid=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en

I don't know what you're trying to do, but I see several mistakes offhand:

1.) you open the parenthesis on the CREATE PROCEDURE but don't close them after the last...

There are reasons you might want to put a non-clustered index on a table that doesn't have a clustered index, for example if the primary key is a uniqueidentifier and...

Concatenation operator in SQL Server is +, not &

If you end up having multiple UPDATE statements in your script, it may be easier to use a TRY...CATCH block instead of checking @@ERROR after each UPDATE:

BEGIN TRY

...