<p>Is there an equivalent schema &amp; data export/dumping tool for SQL Server as there is for MySQL with mysqldump.   Trying to relocate a legacy ASP site and I am way out of happy place with working on a windows server.</p>

<p>Note:  The DTS export utility own seems to export data, without table defs.
Using the Enterprise Manager and exporting the db gets closer with exporting the schema &amp; data... but still misses stored procedures.</p>

<p>Basically looking for a one does it all solution that grabs everything I need at once.</p>

Well, Mysqldump is a series of SQL statements. You can do this with DTS, but why not just create a backup and restore it on your new machine?
If you want to do it via SQL:
http://msdn.microsoft.com/en-us/library/aa225964(SQL.80).aspx
Or just right click the DB and hit Tasks -> Backup (
http://msdn.microsoft.com/en-us/library/ms187510.aspx
)