Alternate option for SQL Server 2008 Management Studio Express

I am trying to install SQL Server 2008 Management Studio Express found here, but I am getting a win32 not an application error.

Is there another option for managi开发者_JAVA百科ng Windows SQL Server databases other than Visual Studio? I just have to be able to log in to the server and run some test SQL like:

ALTER TABLE test ADD column VARCHAR(50)

Can you run that query in Visual Studio? If so that would solve the problem too.

There is the command line sqlcmd utility.

The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt, in Query Editor in SQLCMD mode, in a Windows script file or in an operating system (Cmd.exe) job step of a SQL Server Agent job.

Yes, you can run ad-hoc queries to a SQL Server database from Visual Studio.

Find/create a Data Connection in Server Explorer, right-click, and choose New Query.