Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Ron Carpenter,
This script will generate scripts to create each database on a sever for attach. It handles multiple files, multiple files, multiple files on a filegroup and multiple log files. It will also handle the creation of filestream filegroups. There is a parameter to attach the logs or create the databases for attach with rebuild log. Run the output to text for easy copy and paste.
Multiple attachments using sp_sendSAM
Multiple file attachments with sp_send_dbmail
Problem in attaching database
Attach database file