0

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 ?

Vérace
  • 30,923
  • 9
  • 73
  • 85
Jithin R
  • 1

1 Answers1

2

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.

Vérace
  • 30,923
  • 9
  • 73
  • 85