Well, to solve my problem, here are the steps I took, as the use of BCP simply wasn't available to me on either of the servers.

1.) Script out the CREATE...

Just a thought, but perhaps you could consider having part of your query generate an interim table that contains one column that has ALL the searchable columns joined together into...

What this query is doing is looking at various table names as selected from the database's metadata, and then checking a portion of the table name against what appears to...

There's absolutely no reason you can't use queries to take the information from one database and get it inserted in the other. HOWEVER, a couple of necessities first:

Be absolutely...

Burst ? I think you need to be a LOT more specific about exactly what you mean. While you agreed with one reply that simply substituted...

Thanks for the kind words - glad I could help.

Something to keep in mind, however, is that in using a CROSS JOIN (see next paragraph), you get a cartesian product...

Interesting discussion. Also interesting that no one mentioned the potential inconvenience and/or performance hit of having to use RTRIM on a char field to avoid getting extra spaces...

Here ya go:

DECLARE @LOCATION_TABLE TABLE(

Location varchar(15)

PRIMARY KEY(Location)

)

INSERT INTO @LOCATION_TABLE

SELECT 'MyHouse' AS Location UNION ALL

SELECT 'YourHouse' UNION ALL

SELECT 'MyGarden'

DECLARE @EXCLUDE_TABLE TABLE(

Word varchar(15)

PRIMARY KEY(Word)

)

INSERT INTO @EXCLUDE_TABLE

SELECT 'Your' AS Word

;WITH NOT_WANTED AS (

SELECT...

Yes, and tall task is a bit of an understatement, as I just realized that the transfer time's I calculated would all be doubled, because as an intermediary, the original...

Okay, so exactly HOW is Server1 running this script? Via Enterprise Manager? Query Analyzer? In some kind of application using VBScript, or within an MS Office...

I hate to rain on anyone's parade, but what I'm hearing is that there's no direct connection between the two servers, and there's an expectation of zero down-time. ...

Perhaps Zypsy just needs a little of what I'll call "solution motivation". It seems fairly simple that given the existing data structure, the proposed analysis involving what the...

Kagool,

Thanks for clarifying. You just need to state the entire problem in your initial post, as the design of many solutions is critically dependent on the initial problem...

Sounds like the OP failed to initially disclose criteria that are critical to rendering a proper query. He now introduces the concept of the user replying to a...

You might want to be a bit more specific about exactly what you want to convert to Access, but that query could be used un-changed as a pass-through query in...