Arnold Layne
asked on
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
>>Management Studio is the complete tools for sql server. <<
The author is using SQL Server Express. SSMSE does not support "maintenace plans, schedule job"
The author is using SQL Server Express. SSMSE does not support "maintenace plans, schedule job"
Please instal SSMS from Microsoft site.
ASKER
Thank you.
ASKER