The decision to store real data in a blob fields instead of in a table (one or more) looks quite unusual, and the solution you propose is savvy and natural.

Regarding...

have you solved the problem? I'm experiencieng now something similar. A Linked Server from a SS2K Instance to a SS2K instance is getting the same error (

Server: msg 7399,...

hi Nils,

don't forget that a DOS based solution is still possible. You can obtain a list of files in proper order (sorted by creation date) with a command like this:

dir path /b /o:d

Put...

hi Ethan,

I think that a single data file is absolutely inadequate for a very large db as in your case, specially if it is growing so fast. Without consider performance...

Hi James,

In the past I've experienced a very serious performance issue with SQL Server 2000, WIn 2000 Server (dual proc PIII 900) and SMP. Disabling the multi-processor support in EM, applications...