Thursday, February 17, 2011

In the Visual Studio SQL editor, how do I get rid of the boxes?

I usually create my SQL tables and stored procedures by writing a script inside Visual Studio. This works really well for me except for one simple annoyance: VS puts blue boxes around all the SQL queries and data-manipulation commands. The purpose of these boxes is to draw undue attention to the fact that VS thinks the query can be edited in “Query Builder.”

I don’t want to use Query Builder. I just want a nice, clean script that reflects my fantastic vision of what the DB engine should do. Blast it, Jim, I’m a programmer not a Microsoft Access hobbiest!

I do, however, like the syntax highlighting and source-control integration that VS provides.

So my question is this: How do I turn off the annoying blue boxes?

From stackoverflow
  • Set the color of the SQL query outline to the same color as the background.

  • Open Visual Studio Tools --> options --> Database Tools --> General. Uncheck "Enable DML Markers"

0 comments:

Post a Comment