We help IT Professionals succeed at work.

SQL query tools

Arnold Layne
Arnold Layne asked
on
Medium Priority
230 Views
Last Modified: 2012-05-11
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.
Comment
Watch Question

Software Engineer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Arnold LayneDeveloper

Author

Commented:
Can this be installed on windows 7 with the IIS enabled or does it have to go on win server 2008?
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
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
CERTIFIED EXPERT
Top Expert 2012

Commented:
>>Management Studio is the complete tools for sql server.  <<
The author is using SQL Server Express.  SSMSE does not support "maintenace plans, schedule job"
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
Please instal SSMS from Microsoft site.
Arnold LayneDeveloper

Author

Commented:
Thank you.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.