Opinion:

Passing in a large, constructed string performing an INSERT with of all of the values and then doing an EXECUTE is not an elegant way. First off, it exposes...

I understand your problem as I have also needed the same set of functionality. The solutions presented below have been done within our app (.Net C# and SQL Server...

I'm familiar with the BOM (hierarchical) structure. The assumption is that you already have a Parent/Child relationship. With that, you can navigate up and down the hierarchy.

See my...

Why not use a SYNONYM?

This is an easy solution as long as the "old" table doesn't remain.

You can create a SYNONYM referencing the "old" table to the "new" table. ...

Unlike Oracle, which can perform full-text queries against a view having one or more tables that have full-text indexes, SQL Server is quite dumb in this area.

Independent of the table...

SUBSTRING will return incorrect values from the older SQL Server TEXT and IMAGE data types as it will stop at 8,000 for TEXT (and probably 4,000 for NTEXT). However,...

Jeff,

(clarification)

The "nightmare" is not with the file system per se, but with all of the logic that must be developed managing items (BLOBs, etc.) in the file system with the...

Joseph,

1. Glad to see that the script logic works. Yes, the file size (exact bytes) should be equal to the DATALENGTH value of the VARBINARY or IMAGE column.

2. As...

Jeff,

Just don't blindly state "no BLOBs in the database". At times your application needs to store binary content. Our entire application (inciteKnowledge)(http://www.kadient.com/) is a SaaS solution...

The BCP method with a cursor and [server] command shell appears to be quite kludgy. First off, the extraction of the BLOB is written to the SQL Server server...

For SQL Server 2000, use OSQL, which is a replacement for ISQL. See the Books Online for details about the utility and examples.

Yes, use SQLCMD. However, if you don't like the output format that SQLCMD provides and/or you want to massage the data a bit before writing to the file, the...

Definately go for the dual core. As for memory, 2GB should suffice on the laptop. If you're lucky enough to get 4GB, go for it, as you also...

Suggestion: Store a copy of the HTML in a VARBINARY(MAX) column and then full-text index that.  Use this new column for the search operations (to find the row) and then...

Jeff,

A bit of misunderstanding by my use of the term "object" (I knew it would be read wrong).  It is not an "object" in the OO sense.  It is just...