This script starts in the master database, and then goes to each USER database and creates the DDL for each USER table in every database. You can then save the results or copy them to a new query window to run on another server.
Ever want to display (and edit) ASP code from the original .asp file? (like PHP's PHPInfo() function).To setup: * Just create a .asp with SQL Server connectivity. * Change @IISHostNameWWWPath to match your servername -OR- if SQL Server is on the same machine, use the next line instead. (see […]