Bulk insert SQL Batchfile
Tuesday, June 28, 2011 1:01:00 PM
-U [user id] -P [password] -S [server
] -d [database] -i [full path to script] -o [full path to log file]
sqlcmd -U foo -P bar -S .\SqlExpress -d MyDB -i "c:\scripts\restore.sql" -o "c:\db logs\restore.log"
-o is good for logging errors and print statments. without it errors are not logged (i think.)