Thank you. That took care of my problem.

I am getting an error when I add that in (invalid column name dpages). Can you post the complete SQL?

That will work! Thanks so much for the response.

I was hoping for a simple VBScript that would list all the tables in an array, then list all the columns and attributes and build an insert statement and write...

There are two ORDER BY clauses in a row. The script does not work.

Is there a place I can find any error that may be occurring? I see nothing in the SQL logs. and VBScript does not generate any error, either.

Nope. Making it is ReadAll results in a Object doesn't support this property or method: 'oStream.ReadAll'.

This is VBScript (interpreted) and not VB6 because that might make a difference. ...

I keep getting errors related to a view:

Msg 207, Level 16, State 1, Line 1

Invalid column name 'Short Name'.

Msg 4413, Level 16, State 1, Line 1

Could not use view or...

My guess is the difference is time. Mine was early in 2008. That was before the economic crisis got really bad. Toshiba has obviously cut back work...

I had an issue with a Toshiba laptop in 2008. It was about 13 months old. I had purchased a three year warranty. I would advise that....

Perfect! Thanks for a very cool solution and the mods to make it workable for me.

How would I do this since there is already a JOIN to sysschedules? Sorry, I am not a system DBA.

Thanks. I got the same error. The corrected script works great.

I am getting a bunch of syntax errors:

Msg 102, Level 15, State 1, Line 11

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 41

Incorrect syntax near '?'.

Msg 102, Level...

The 2005 version posted worked great! Thanks to all of you.