You're absolutely right, I wrapped that value in [] and it didn't affect it at all, same error, so would it then be that it doesn't know the schema?

I'm just...

I think that your procedure will work, I need to search for partial credit card strings

so perhaps 1234________5678

where the underscore is any character be it with dashes or without dashes.

So...

Lowell, I think this might work!

So basically I just modify the @sql variable's text a bit and change the paramater going into the stored procedure to do the searches?

Thanks I'll...

Matt, I actually found and tried that script, but it doesn't seem to have the ability to add wildcards, and it also doesn't gracefully handle the poorly formed tables names...

So I left out some of the details in the hopes someone already has something written for this. I am aware of the resources this is going to take,...

Perhaps that's what I need, though I might be missing the point on how I'd use it. I need to search through the rows in every column in the...

Well for anyone that's curious, I figured out what was going on. The vendor had uuencoded the binary data and inserted it into the ntext field. yeah...

Thanks for your reply, this is a little different I think than dealing with excel outputs, these are actual binary files that from what I can tell the vendor has...

I think I have figured out what the problem is, the column called FILEBLOB is of type ntext and when exported, exports as ntext. Is there a way to...

Depending on if it is t-sql or ssis there are several ways to handle locking.

The easiest is to use join hints:

select

columna,

columb

from tablename with (NOLOCK)

Keep in mind that this will mean...

Forgive me, I'm fairly new here but my understanding of AWE suggests that it doesn't affect SQL's ability to limit it's max memory usage. The fact that when you...