Thanks.  It's nice to know it's not just me - this time. 

I also noticed that a DTS package I saved from a client with SP4 would not open or run...

The data displays when I use LEFT(col, 800).  I thought about special characters, but using LEFT on the same data enables it to display.  In any case, why would they be...

Can the process producing the file add the delimiters for the missing fields?  Otherwise, if the record length is always less than 8000, the data could be loaded into a...

1) If you have file backups, you can use those to restore each db.  2) You can also "attach" each database using the mdf and ldf files in the Data...

It does appear the order is fine.  I did not worry about order because this is just the start.  The actual document is much uglier - as is most of the...

Thanks for the clues.  It now works - amazing.  A lot of work.  I did not work out the "order by" yet.  -Randy

Final result:

SET NOCOUNT ON

SELECT RTRIM(a.AddressId) as...

Groan.  Thanks for the replies.  I was hoping for a simple life. 

I'm writing the XML to validate against the GJXDM (Global Justice XML Document Model).  It determines the sequence. ...

I sure would appreciate any help with this, even if it is to know that it can't be done with FOR XML EXPLICIT. 

Did you check the EventLogs on each system?  Maybe there is a network hardware or configuration problem. 

You can drag a shortcut to the taskbar's "Quick Lauch" toolbar.  I normally use that in the start menu.  Right click and drag the shortcut or program to the toolbar...

A trigger is a stored procedure like T-SQL that executes in response to inserts, updates, or deletes.  It is not related to keys or indexes. 

Every table should have a...

It's also not impossible that a developer, after testing, forgot to remove a "top" in a select statement or a SET ROWCOUNT statement. 

If you got no results, I would expect resource limitation, batch size, bad design, etc.  However, since you are getting an incorrect result, I would expect a data or logic...

In some cases, it's a good idea to restore to a new database, leaving the original alone.  If you can find the missing data or objects in the new database, it...

The udf is returning TABLE data_type - it's used in a FROM.  Unlike in a temporary table, the storage will be in RAM.  Something to worry about if there is a...