Anyone running SQL2008?

[chris421]

The SQL2008 "Filesystem" installation option for BLOB handling looked interesting.

http://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-manage-unstructured.aspx

Wondering if this could help NWNX users who store lots of large objects to their databases. It’d be nice if persistent henchmen worked a little smoother.

[Gryphyn]

You can already do it!
See the SQLServer plugin (by Gryphyn) *blows own trumpet*

There is a catch with varbinary(max) using ODBC in that anything over 8000 bytes returned 0xFFFFFFFF (UNKNOWN) which the ODBC plugin takes for an end-of-buffer. (fixed in the SQLServer plugin)

2008 introduces a "FileStream" type/method that caters specifically to multi-media type data (music, video etc). The advantage of this is the asynchronous assess that is available - not really suited to NWNX.

As for using 2008, I've migrated my 2005 systems to 2008 with no issues.

Cheers
Gryphyn