Customizing a comment

Question

Customizing a comment

a1011

SSC Enthusiast

Points: 180
More actions
March 8, 2010 at 10:36 am

#221397

I want to customize the way comments appear. Right now comments appear with a green script. Is there anyway I can customize them so that they are bold with a yellow background so that they are easier to notice and read?
Thank you

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

What comments, where, in what application?

If you're talking about Management Studio, go to the tools menu, select options. In the resulting dialog expand out environment and select "Fonts and Colours" Make sure that the drop down at the top is set to "Text Editor". In the list box in the center scroll down to "comments" and select that. Then you can set the item foreground and background to anything that you want, you can change the font and size and make it bold.

Those settings are specific to your Managment Studio.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

a1011 SSC Enthusiast Points: 180 More actions · Answer 2

I meant comments in SSMS where you write the query. But I just found out how to do it...

Go to tools in the menu bar in SSMS...choose options....Expand Environments....Click on Fonts and Colors...then select Comment under Display Items. Then change the type of font and color you want the comments to appear.

SQLRNNR SSC Guru Points: 281344 More actions · Answer 3

a1011 (3/8/2010)
I meant comments in SSMS where you write the query. But I just found out how to do it...
Go to tools in the menu bar in SSMS...choose options....Expand Environments....Click on Fonts and Colors...then select Comment under Display Items. Then change the type of font and color you want the comments to appear.

Thanks for posting back. Since you found it, I will leave it be - that is what I was assuming you were driving at.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events