Check out this article, http://www.sqlservercentral.com/articles/TSQL/62867/ as it addresses this issue.

You need to check the data_type column in information_schema.columns for IMAGE or varbinary and when varbinary then if the character_maximum_length = -1.

Sounds like something you should be doing within Excel with VBA, so an Excel site may be a better place to ask the question.

This works. There may be a more efficient way, but now you will be on the front page of "Active Threads" again too.

SET DATEFORMAT dmy

DECLARE @lookup TABLE

...

Cool. Thanks for posting what you found. I love it when I learn something new.

As I've read through the responses a common theme has been that people already know what is right and wrong or moral or ethical, yet can someone provide a definition...

I don't know about order, but you do not need to reorganize and rebuild, do one or the other, and there are scripts available here and other sites for determining...

The one thing I understand about UNION and UNION ALL is that UNION ALL should perform a bit better because it does not have to eliminate duplicates (sort and compare)...

A block occurs when a resource has been locked by an process and another process with an incompatible lock type attempt to acquire a lock on the same resource. ...

I don't believe that there is a way to do this in a Matrix.

First I am going to suggest that you read this article[/url] as it addresses some things you are doing in your trigger that are not best practices.

Secondly, can you...

Seconded

Can you post the DDL and sample data so we can possibly try to duplicate the error and test any solution?

Here are a couple of links that may help you:

http://support.microsoft.com/default.aspx/kb/325197

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

It sounds like the second one may be more like your issue.

DT_NTEXT is the SSIS equivalent to nvarchar(max) which is what you want to use in SQL Server for converting an ACCESS memo column because ACCESS uses UNICODE.