CODEWITHSUNDEEP
sql-servervisual-studiowindows-server-2008ssms
Mike
Mike

Reputation: 12819

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 managing 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.

Upvotes: 1

Views: 547

Answers (2)

p.campbell
p.campbell

Reputation: 100557

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.

alt text

Upvotes: 1

Oded
Oded

Reputation: 498904

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.

Upvotes: 3

Related Questions