Where can I find SQLCMD?

Hot Topic

SQL Mobile performance/size problems with WM5 device
reseeding temporary tables or table data types with identity column
Is this method possible?
Microsoft SQL Server Mobile Edition data source
Problem with date range and aggregate function
cannot install SQL Server Express, keep getting errors
SSIS From SQL2K5 to MySQL
Issues while loading in parallel into a partitioned table
Reporting Services Performance
Using SSMS to Manage SSIS

SQL Server

SQL Task - Output Parameter fails using strings.
Inconsistent package failures
Express Manager download for RTM version of SQLServer Express
SQL Server express starting as NETWORK SERVICE!!
how to fixed the size of the report and landscape view state?
The operation has timed out
Passing variables to data flow component
Resources about Load/Run SSIS packages using .NET Remoting.
Communications to the remote server instance failed before database mirroring was fully started
What are the best practices for a time dimension?

Where can I find SQLCMD?

Hi, all here, where is the SQLCMD (to run sql scripts). I mean I did not find SQLCMD on the SQL Server tho.

Thanks a lot in advance for any help.




Answer this question

Where can I find SQLCMD?

  • LuisLopezCarrete

    Hi, for me its located in

    C:\Program Files\Microsoft SQL Server\90\Tools\Binn

    HTH, Jens Suessmeyer.

  • Shon

    Hi, Jens, thanks a lot. Found it in the folder. But I cant run sql scrit in it tho. Could you please tell me how can I run any sql script in it (I have my database .mdf and .ldf files available, I wanna attach the database to the SQL Server instance through this command window)

    Thanks a lot.



  • Kevin Feasey

    Hi, Jens, thanks a lot.

  • Matt150279

    Put the database files in the appropiate folders where you want to store these, then use the Sp_Attachdb procedure to attach the databases. More information about the syntax can be found in the BOL. If you have more questions on this or need a hand on this, just tell us.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • Where can I find SQLCMD?
Answer this question