SQL Server 2008 Management Studio - Technology tips

Wednesday, April 7, 2010

SQL Server 2008 Management Studio

SQL Server  2008 Management Studio is free version from Microsoft you can access, manage and administer your database, there are some limitation as Microsoft has released  sql server  management studio for free, this tools solely used by sql server developer and administrator as they could see graphical user interface once they install it and they can easily work with the database.
Ideal scenario of using sql server management studio, you have sql server running on machine A and you want to access your database from developer machine B with visual studio like you want to view data before manipulation. Then you need to install sql management studio on machine B and access you data from there.

If you want to access data that has been stored in sql server 2005 then you need this version otherwise you need SQL Server 2008 express is also a free tool if your data has been stored in SQL Server 2008.

There are different version available on Microsoft site of this free tool but recently sqlserver management studio express edition can the best choice for anyone who is going to manipulate data using this tool,but before mentioning all details I will elaborate how you can make auditing done with SQL Server 2008 and then you can find fine more details on Microsoft site.

Why audit has been very prominent in the entire life of DBA- it gives them detail about who has accessed and attempted to access your data, I will also outline few more things about regularity compliance why they are related with audit and all this.

There are many acts in the world in relation with the audit mentioned here- it means how they can monitor data stored in databases – so these compliances ensure the real audit theory as per the organization type.
SSMS can help you audit on sql server database level and sql instance level when you configure audit you have option at what level you want to trace it.

This audit is life for DBA's because they can track many events with this functionality.
You can create audit object by using ssms just point your location to security folder and right click on audit folder and create new option, and it's done.

SQL Server 2008 R2 has been supported and compliance with HIPPA, please read other article on this site for HIPAA and PCI.

Various versions of sql server management studio
there are some other versions of sql server management studio you may find -
Latest version of SQL Server management studio 2016
Along with this there are various previous version of sql server management studio by Microsoft.
Sql server management studio 2014 sp1 having some azure feature and
Sql server management studio 2012 sp3 with full feature
Sql server management studio 2008 express
Ideally you can install this client tool with the sql server running on server and if you have confusion with that which sql server is installed so simply load sql server configuration manager and click property from there you can see which version of sql server installed then you can install any client tool on any client machine in order to hook up with DB’s and other object and perform tasks.
You can also try all previous version of sql server management studio like
You can manipulate various sql server instances means is simple there are many sql server hosted instances has been installed and sql server management studio is the only tool that will help you to manage other instances on the same sql server.
So if you have ended up with correct version of sql server management studio installed along with your sql server you can easily manipulate data and DDL, DML on you relational databases.

sql server management studio
sql server management studio

we will elaborate on audit feature of sql in our next articles.
I will outline more details about audit next time but now you can download SQL Server  Management Studio from principal vendor Microsoft.


Anonymous said...


SQLServerStudio said...

Sorry Anonymous, I think it's

Privacy Standard/Rule (HIPAA)

Health Insurance Portability and Accountability Act (HIPAA)- please correct me any one else ...

Anonymous said...


Anonymous said...

so your idea of a download link is microsoft.com?


SQLServerStudio said...

Sorry Lame, if you could not find a download link from Microsoft, basically we can not mention the exact URL for Microsoft.
But thank you for taking interest in our site.

USMAN said...

can someone please guide me or direct me towards a good resource to learn how to get started with sql server 2008 management studio..

sharepoint said...

Wonderful content about sql server management studio, been trying something which could distinguish among these products and finally we come up with the perfect version of sql server management studio we should use with our environment.

Jack T said...

good learning on this site, but I want to install sql server 2008 management studio on my client so I could access from remote server because our databases are there on remote location.. any idea

Anonymous said...

Great info about SSMS please keep it up.
Abbas, Abu Dhabi- UAE

Anonymous said...

please post all previous version of sql