SSMS and SSMSE difference | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SSMS and SSMSE difference

What’s the difference between "SQL Server Management Studio" and "SQL Server Management Studio Express"? Is there any link to explain this? In the company that I was recently hired, there is a SQL Server 2K5 Enterprise Edition installed on the server. Another DBA instructed me to download and install SSMSE on my computer. I am supposed to administer the SQL 2K5 and I am new in 2K5. I have worked with 2K and EM and QA for years. Question is that should I continue with SSMSE and learn it? Or use SSMS? If SSMS how can I download it? Where should I look for it?
Thanks, CanadaDBA
SSMS comes with SQL2005 (lisenced client install !)<br /><br />SSMSE is designed for SQL2005 EXPRESS edition (free) <br /><br />msn-Search [<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />] for "Microsoft SQL Server SQL Server 2005 Features Comparison"<br /><br />
features like replication, dataabsemail etc are not avaialbe. but you can execute the queries —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
As a good start you can use SSMSE to get more understanding of what it does and then go to SSMS for manageability. As referred previously Books online is the best resource for you to get a better understanding of these tools and equally to this forum/ Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Where can I find SSMS? Is it in the SQL 2K5 CD? If yes, they how can I install SSMS without installing the whole SQL Server (from licensing point of view). We have one license for the one installed on the server. CanadaDBA
You can choose to install Management studio alone without a server installation on your desktop, setup automatically begins the client tools installation based upon the operating system version. http://www.databasejournal.com/features/mssql/article.php/3499231 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>