If you don't have an MSDN subscription you can order the CD:

http://www.microsoft.com/uk/windowsserversystem/reporting/howtobuy/default.aspx

which says in part:

If you are a current SQL Server 2000 customer,...

Mike, can you be more specific? Basically you would create an ODBC connection and DTS the data into SQL Server.

Each dbase table is a separate DBF file; if it has...

Sorry Simon, I would not recommend pursuing the MCDBA unless you've already started that exam track. Microsoft will be ending mainstream support for SQL 2000 around April of NEXT YEAR....

The pass-thru query to SQL Server should still run the same, since Jet does not touch that. But joining the resulting data to local Access tables will always be a...

I should have added that after you create the script from EM, you'll need to edit the resulting CREATE DATABASE statement to specify the file name, logical name, and the initial...

I would suggest scripting the complete 2000 db and then running the script on 2005 to test for incompatibilities.

If the original developer used reserved words for tables or columns, 2000...

Matthew, you should also check BOL for usage of the IF statement, which basically works two ways:

IF (expression)

(only the next statement is executed if expression is True)

the second...

That's right, only 2000 Enterprise can use more than 2GB. Sorry about that.

One spec that's missing from this list is the max RAM - both Standard and Enterprise can use as much as the OS can support, either 32- or 64-bit. The...

I found two good articles:

A transaction log grows unexpectedly or becomes full on a computer that is running SQL Server

http://support.microsoft.com/?id=317375

INF: Causes of SQL Transaction Log Filling Up

http://support.microsoft.com/kb/110139/

...from what...

Rod,

It is possible that you have more than one ProviderNumber = 105?

Since [aaaaaProviders_PK] is your primary key, can you try the update using that in your Where?

Colin, you said

"third party apps that clients buy - these seem to usually contain every bad use of sql and sql server, but that's another story."

If you're starting a new...

I believe in placing as much as possible in the database itself. Considering the rate of change in Visual Studio releases, if you use the CLR integration, there's bound to...

Great article Andy! And what a great discussion, too.

I've used cursors once in a while when they were the best solution, most often when working with a poorly-constructed application, to match...

The "best" solution is not to use dynamic sql unless there is absolutely no other way to accomplish the desired result.

Dynamic sql is a total pain to maintain. I've slogged...