Top "Sqlcmd" questions

SQLCMD is a command line tool used to run SQL batches on Microsoft SQL Server.

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? …

sql sql-server sql-server-2008-r2 sqlcmd
Return value of SQLCMD

I need to check the exit status (success/failure) of a query run through SQLCMD utility. For example, the server …

sql-server windows sqlcmd
SQL Server 2008 in single-user mode allows no connections

I don't know the SA password so I restarted my SQL Server 2008 Standard Edition instance in Single-user mode with the …

sql-server sqlcmd
sqlcmd won't run - Is this a config issue?

I'm trying to use sqlcmd to execute some SQL scripts. Using a test command with a simple query like: sqlcmd …

sql sql-server tsql sqlcmd
sqlcmd with output file and screen output

I do some command line batch (.bat) with sqlcmd as this way: sqlcmd -i Scripts\STEP01.sql -o PROCESS.log …

sql sql-server-2005 command-line sqlcmd
sqlcmd script with spaces in filename

I have a simple SQLCMD script that includes some lines like this: /* Load data into Exampletable */ BULK INSERT dbo.Example /* …

sql sql-server csv bulkinsert sqlcmd
How to change the port when calling sqlcmd

I have this command sqlcmd.exe -E -i "C:\joe-db-scripts\joe-db-tasks.Install.sql" and I need to add the specific …

sql sqlcmd
How to use `sqlcmd` command without username and password in SQL Server 2008?

How can I run commands, passed to sqlcmd, as currently logged on user automatically i.e without having to enter …

sql-server-2008 authentication sqlcmd
How to format SQLCMD output

I am using below command line to run a SQL query using SQLCMD sqlcmd -S Server -Q "select top 100 * From …

sql sql-server powershell sqlcmd
Exporting CSV data using SQLCMD.EXE

I'm trying to export data from SQL Server into CSV format. I have a bat task to do this that's …

sql-server csv sqlcmd