Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 3 down vote favorite
1

I get an odd problem in my SQL R2. Although I can attach a new db to my db instance, but all buttons on the tool menu panel are disabled. So I cannot execute any sql query statements. It is really annoying !!! I have been stuck on it for ages.

Could someone help me figure it out?

All buttons disabled

Thank you so much.

share|improve this question
Yes you can. Click New Query and a new query window should open up. Then you can execute your SQL query. As for the grayed out buttons, your object explorer is already connected, which is why I'm guessing those buttons are disabled. Regardless, you shouldn't be prohibited by that screenshot. – Thomas Stringer Jul 17 '12 at 14:00
@Shark, thank you for your timely reply. I have tried to click "New Query", it did pop up a new query window, but all buttons remain disabled. – Franva Jul 17 '12 at 14:07
You need to have an actual query window open in order to be able to click "Execute." You can do this by clicking the New Query button or by right-clicking the server and choosing New Query. – Aaron Bertrand Jul 17 '12 at 14:08
@Franva can you show a screen shot that includes your cursor in the New Query editor window and the Execute button is still disabled? Not that I don't believe you, but... – Aaron Bertrand Jul 17 '12 at 14:08
@Aaron Bertrand, Hi Aaron, thank you for your reply. I am not a beginner in SQL. I did try open a new query window and selected my query statement. Execute button still remains disabled. I am running a repair program, will show you the screenshot in 2 mins. – Franva Jul 17 '12 at 14:13

migrated from stackoverflow.com Jul 17 '12 at 14:05

1 Answer

up vote 2 down vote accepted

I have found the solution for this issue.

Simply go to Start -> Microsft SQL Server 2008 R2 -> Configuration Tools -> SQL Server Installation Center (64-bit)

Then go to the Maintenance option -> Repair.

Done.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.