Today's post will take us back almost 14 years, back to SQL server 7!
I often see that question in forums, and some people are confused it with BIDS or don't know what its usage.
SSMS stands for SQL Server Management Studio, lets you connect to your database servers to explore ,edit and create data, tables, views, stored procedure and such database objects. where you write your T-SQL.
Also allows you to configure your server's properties, do your backups, connect to the SQL agent, and it gets installed as part of the client tools installation, using the SQL server CD or DVD.
It was introduced in SQL 2005 and above, prior to 2005 for example in SQL 2000 it used to be called enterprise manager.
SQL server 7 Enterprise Manager
SQL server 2000 Enterprise Manager
SQL server 2008 SSMS
SQL server 2012 SSMS
You can read more about it here...
http://en.wikipedia.org/wiki/SQL_Server_Management_Studio
http://msdn.microsoft.com/en-us/library/ms174173.aspx
Hope that helps someone...
I often see that question in forums, and some people are confused it with BIDS or don't know what its usage.
SSMS stands for SQL Server Management Studio, lets you connect to your database servers to explore ,edit and create data, tables, views, stored procedure and such database objects. where you write your T-SQL.
Also allows you to configure your server's properties, do your backups, connect to the SQL agent, and it gets installed as part of the client tools installation, using the SQL server CD or DVD.
It was introduced in SQL 2005 and above, prior to 2005 for example in SQL 2000 it used to be called enterprise manager.
SQL server 7 Enterprise Manager
SQL server 2000 Enterprise Manager
SQL server 2008 SSMS
SQL server 2012 SSMS
You can read more about it here...
http://en.wikipedia.org/wiki/SQL_Server_Management_Studio
http://msdn.microsoft.com/en-us/library/ms174173.aspx
Hope that helps someone...
No comments:
Post a Comment