Search code examples
ssmssql-server-2008-express

How to control SQL Server 2008 Express without SQL Server Management Studio (ssms)


I Installed SQL Server 2008 Express on a client PC (I install SQL Server 2008 Express from Visual Studio Setup Version for C# program)

But I don't see SQL Server Management Studio icon in all programs windows.

Now if I want control tables and database in SQL Servers, how can I do this?


Solution

  • Just installing Sql Express on it's own will not give you any client tools.

    If you have a full Sql Server (Dev or otherwise) already installed on the same client, the existing tools will allow you to manage the Express database instance too. Otherwise, you wil need to install the version of Sql Express that comes with tools. This can be found here

    Sql Express with tools