What's the difference between SQL Server Management Studio and the Express edition?

sql-server ssms
MrBoJangles picture MrBoJangles · Sep 22, 2008 · Viewed 70.1k times · Source

I'm using Express currently. What extra features do I get with the full edition?

Answer

Ricardo C picture Ricardo C · Sep 23, 2008

There are no differences in Management Studio. The differences are in the database engine LIMITATIONS! The engine is the same but it will deny you some features.

Import/Export wizard in the express edition can be found at: C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

If you dont have it, dowload it from Microsoft: http://go.microsoft.com/fwlink/?LinkId=65111

You could install the Microsoft SQL Server 2005 Express Edition Toolkit to get the cool toys, like the Import/Export wizard and the reports.

The profiler is not part of Management Studio. It is one more application that comes with the full version of the SQL Server. Even if you have it installed your express edition server engine will refuse to work with it.

Related questions

How do I set a column value to NULL in SQL Server Management Studio?

How do I clear the value from a cell and make it NULL?

Read More
Insert Data Into Temp Table with Query

I have an existing query that outputs current data, and I would like to insert it into a Temp table, but am having some issues doing so. Would anybody have some insight on how to do this? Here is an …

Read More
How to see query history in SQL Server Management Studio

Is the query history stored in some log files? If yes, can you tell me how to find their location? If not, can you give me any advice on how to see it?

Read More