I am currently using Management Studio Express to administer remote SQLServer databases I support as a DBA. I notice that I cannot "see" DTS packages on the remote server from Express, but when I login directly to the server (Term Services) and use the local Management Studio (Full?), that I CAN see the DTS packages.
1) What are the other differences between Management Studio Express and Management Studio "Full"?
2) Is it possible to aquire and install (upgrade) on my workstation, to Management Studio "Full" so that I can take advantage of the additional capabilities the "Express" version does not have, in order to manage my remote servers?
TIA,
Phil Streiff, MCDBA
There are quite a few differences between SSMS and SSMS-Express.
You can obtain (and be properly licensed for) SSMS with SQL Server Workgroup, Standard and Enterprise Edition.
|||Thanks Arnie,
I will definitely upgrade to SSMS now, based on your input.
I suppose I have to pay for the SQL2K5 Standard or Workgroup license, even though I'm only installing the Mgt Studio on my workstation and not the whole database engine.
Phil
|||SS 2005 Workgroup Edition is about $750 with 5 CALs. (Maybe better pricing is around.)
IF you were in a dev environment, you could get SS Developer's Edition for about $50. But I don't think that it would be legit to manage production servers.
Maybe one or more of your clients provide you with SSMS to manage their servers.
For definitive licensing questions, call the licensing folks at:
Licensing –VL Contact
(800) 426-9400
Good Luck!
No comments:
Post a Comment