[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

SQL query tools

I have the SQL server 2005 edition that comes with Visual Studio 2008, so i suppose it's the express edition. I can't seem to find any query tool for this. Can anybody point me in the right direction?? Thanks.
0
BobHavertyComh
Asked:
BobHavertyComh
3 Solutions
 
Ephraim WangoyaCommented:

That could be the compact edition.

You can download management tools from
http://www.microsoft.com/express/Database/

Just make sure to instal  the management tools
0
 
TonyRebaCommented:
The one you need is SQL MANAGMENT STUDIO EXPRESS.   Thats a free edition
0
 
BobHavertyComhAuthor Commented:
Can this be installed on windows 7 with the IIS enabled or does it have to go on win server 2008?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
TonyRebaCommented:
Yes, it can be installed on Win 7 . Just look for the right version for you, I know there is a 32 and a 64 bit edition.

Good Luck
0
 
CboudrozCommented:
Management Studio is the complete tools for sql server.  You can do query, query statistics, query plan, object modification, security, maintenance plan, activity monitoring, schedule job... ...

but you can also make query inside the visual studio whit the database tools, it's limited in option, but you should be able to accomplish basic query and object modification whiteout problems.

Open VS 2008
Go on "View" -> "Server Explorer"
Add a new data connection to the database
now you can browse the database and make query

see attach picture.


vsDatabaseTools.jpg
0
 
Anthony PerkinsCommented:
>>Management Studio is the complete tools for sql server.  <<
The author is using SQL Server Express.  SSMSE does not support "maintenace plans, schedule job"
0
 
Alpesh PatelAssistant ConsultantCommented:
Please instal SSMS from Microsoft site.
0
 
BobHavertyComhAuthor Commented:
Thank you.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now