Is it possible to use the sqlcmd command to dump table structure the way it can be done with mysqldump?
A:
You would need to load on a stored procedure first. The one I keep going back to is:
http://vyaskn.tripod.com/code.htm#inserts
I owe the guy that made it a couple of pints as it has saved me a load of hassle over the years.
Burt
2009-11-09 16:37:32
This is a good tip. Unfortunately it won't work in this case because I don't have permissions to install a stored procedure on the source database.
andrew
2009-11-28 20:43:17