Spent the last 2 hours trying to diagnose an error message. I am writing a batch file which simply executes a SQL script using sqlcmd. This is the command:
sqlcmd -S %SQLServerName% -E -i InstallSql.sql > InstallSql.txt
For the life of me, I have no idea what is going wrong. The error message is incredibly useful
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Syntax error, permission violation, or other nonspecific error
Ok, so it could be one thing, or maybe it’s another, oh actually it could be anything at all really. Essentially they're saying YOU ARE ON YOUR OWN WITH THIS ONE, trial and error is the only way.
Anyone got any ideas what this could be? I’m gonna throw my laptop out of the Window soon!