It takes 10 years for several reasons:

1.) Training is almost always completely inadequate, starting with the large number of incompetent college professors teaching the computer courses, and ending with corporate...

Actually, you might NOT disagree, depending on what PaulB meant. One could interpret what he said as meaning that his reference to "should be the DBA", means that...

I thought I would show how you could have used the UNPIVOT & PIVOT functions, given that you were unable to do so. This is just another method,...

In a previous job, I was a Server "Break/Fix" tech, and that meant performing backup monitoring (and changing backup tapes), monthly re-boots at oh-god hundred Sunday mornings, monitoring disk space...

Also, I would never verify anything on a server via Terminal Server. Log on locally directly on the server, or at least use Remote Desktop to do so....

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...