Could you not load a backup of the database and generate the scripts from there?

Hi,

The connections are made through ODBC.  The applications that connect from the web servers are perl cgi.  The entire system has been operational since 1999 and handles several thousand hits...

select lg.field1, sm.field1

from largetable lg, smalltable sm

where lg.printkey *= sm.printkey

Assuming that the database is offline, you could try sp_attach_single_file_db

Thanks for your reply.  In my case, dropping and recreating the clustered indexes fixed the problem.

I assume that you have the hand sign that indicates that a database is setup for replication.  If so, and you don't want that database to be replicated, you can execute...