select * from table 1 union select * from table 2 should do it.  If you wish to have all rows from both tables returned (in your example, row 1,...

Search the scripts database, there are a couple of very good scripts for generating documentation of your database. 

Also, you may want to check out http://www.ag-software.com/.  They have a...

You said you tried Server.ScriptTimeout = numseconds but did you try Server.ScriptTimeout = 0 seconds.  This should effectively turn ScriptTimeout off.

try executing xp_fileexist to see if the file exists.  Alternatively, you can select from syslogs to find out the expected locations of the .mdf/.ldf files.

When importing from excel, SQLServer checks a predetermined number of rows to determine the datatype.  IIRC, the default is 8-10 rows.  If your first 8-10 rows contain integers, it will...

From BOL

Transact-SQL supports two methods of building SQL statements at run time in Transact-SQL scripts, stored procedures, and triggers:

• Use the sp_executesql system stored procedure to execute a Unicode...

Aaron,

Thanks for the reply.  I had already solved the problem though it was good to see that my solution was essentially the same as yours.