Top "Sqlcmd" questions

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

How to export data as CSV format from SQL Server using sqlcmd?

I can quite easily dump data into a text file such as: sqlcmd -S myServer -d myDB -E -Q "select …

sql-server file csv sqlcmd
How do I grant myself admin access to a local SQL Server instance?

I installed SQL Server 2008 R2 to my local machine. But, I can't create a new database because of rights (or …

sql sql-server sql-server-2008 ssms sqlcmd
How to export SQL Server 2005 query to CSV

I want to export some SQL Server 2005 data to CSV format (comma-separated with quotes). I can think of a lot …

sql-server sql-server-2005 bcp sqlcmd
Is there a way to suppress "x rows affected" in SQLCMD from the command line?

Is there a way to suppress "x rows affected" in SQLCMD from the command line? I'm running an MSBuild script …

sql-server rows sqlcmd suppress
How to connect Sqlcmd to the server?

I just installed SQL Server 2008, and I wanted to use the command editor to execute queries. To do that I …

sql-server-2008 sqlcmd
SqlServer 08: Query to list all databases in an instance?

How do I list all the databases for a given sql server 08 instance using sqlcmd?

sql-server sql-server-express sqlcmd
How to execute sqlcmd from powershell?

I have a string in powershell, which contains a native sqlcmd command. The command itself can be executed successfully in …

powershell sqlcmd
Run sqlcmd without having SQL Server installed

I'm working on a Java program that is calling sqlcmd. It works perfectly on a computer with SQL server installed, …

java sql-server sqlcmd
Remove column header from SQL Server query result

I want to remove column header from SQL Server query output. I did the search but not found any solution. …

sql-server sql-server-2008 powershell sqlcmd
How to use sqlcmd to create a database

I have a .sql script and I want to build a database from it. How to do it in sqlcmd? …

sql-server sqlcmd