I have 1 win7prof fresh system. Now I want to connect to a DB instance remotely via sqlcmd/any other way. My req is to connect and execute select query? is there any method/software needed to be installed in fresh win7prof system to access the instance.? kindly let me know what to do for access and use manipulation operations ?
I checked this out and the latest available standalone for SQL Server Management Studio is a 2008 version here.
Thanks to @AaronBertand, the process of obtaining the SQL Server Management Studio 2014 involves clicking the download button for the full SQL Server Express 2014 and then you will be offered a choice of only downloading the Studio (see here - with thanks again to Aaron Bertrand). Detailled instructions available here.
If you just want a command line client, then check out this post.