Here is a feature that I have been waiting for since I started working with SQL Server 6.5: the ability to script the data from a table. When you deploy a SQL Server database, you often need to ...

However, even though i specify no password on the command, the script does not wait for a user input and just carries on regardless and errors out. What would be a better, generic way of doing this ...