Tagged Questions
3
votes
3answers
197 views
Is there a way to tell SQLCMD not to output rows to text or a file?
I am testing the behavior of a SELECT statement that returns 170,000,000 rows using SQLCMD. My goal is to cut out the time spent receiving the result-set on the client end (the time the process shows ...
3
votes
2answers
404 views
Suppress SQLCMD messages
Would it be possible to suppress all sqlcmd messages output to the cmd window?
I am running a large script and it seems to be slowed down a lot with all the Processed XXXX total records messages.
...
4
votes
3answers
378 views
How to transfer files at remote location using sql server job?
I have a job configured in which it transfers the file at remote location.
My command is running absolutely fine from the command prompt but when I configured it in sql server job it gives log on ...
2
votes
0answers
158 views
How to get SQLCMD to output errors and warnings only?
How can you get SQLCMD, when executing a SQL script file, to just output any errors or warnings it encounters?
I essentially dont want information based messages to be output.
12
votes
2answers
11k views
How to pass in parameters to a SQL Server script called with sqlcmd?
Is it possible to pass parameters to a SQL Server script? I have a script that creates a database. It is called from a batch file using sqlcmd. Part of that SQL script is as follows:
CREATE DATABASE ...
