Daniela,

Do you want to load the location of a file into a record or do you want to load the file itself into the table?

When I read your original post...

This is my first thought and the may be a little indirect, but you could create a job on your local box that queries a table in the remote database. ...

I'm not going to go quite as far as DCPETERSON here, but I would agree the author of the article SHOLIDAY posted expresses an inconsistent and self-contradictory view in the...

In theory, theory and practice are the same.  In practice, they are not.

There’s no place like 127.0.0.1  -Dorothy's geek sister

"You should be able to add columns (GUIDs or otherwise) to a table without affecting the current application as long as the applications queries avoid the "SELECT *" approach."

dcpeterson makes...

If you are sure that the owner and all permissions are the same as other tables and queries run in Query Analyzer, it sounds as though the problem is not with the tables. ...

In my earlier response, I should also have mentioned the need to repopulate the index after any data changes.  The first few times I added records I couldn't find them with...

I think you have one problem with the query and one change I can't yet explain.

The problem is searching for a string 'ABC' which does not exist in the field. ...

Could you provide a little more information about what you are trying to do?  I'm not clear on what the business rules are.

It sounds as though your business rules allow...

You've probably already considred this, but it sounds as though your tables seriously need to be redesigned.  A field such as this with some (but not much) structure usually is...

As bellis points out,  the UNION requires both queries to have the same number of columns with compatible datatypes.

Since you will have an extra column in every record of the...

Because the two queries return different columns and you mention an additional join, I am going to infer that you want one query (the first query with the column from...

I had a similar problem a while back.  You might want to check out the Microsoft KnowledgeBase article 281642 for some background.

I took a short cut which involves editing a system...

M.S.

It may help to 'start with the end in mind' as the management guys like to say.  It would help if we know what you intend to do with the...

If you (or other users) want perform more analysis work on the data, you may want to distribute the results of your queries in Excel.  This  allows the recipient to...