Unable to enable SQLCMD in Management Studio

Question

I can call SQLCMD from command line but in Management Studio I see it has a warning (red exclamation). In Tools,
By default, open new  enable in SQL CMD mode has been checked.

Answer 1

 

"Flip to SQLCMD mode in Query tab."

This is where the problem is. It has a warning sign attached to it. Nothing happens. Probably a bug!!!

Answer 2

In Query tab, SQLCMD mode, I have red exclamation point on it, but it flips. It shows a rectangle around it after the flip. Also SQLCMD commands work.

 

 

 

Answer 3

Thanks. It does have a rectangle around it. The ! point is something the designer forgot to remove. Yes the SQLCMD commands do work.

Answer 4

In SQL Server 2008 R2, I cannot make it NOT show a rectangle around it.  It does not toggle.  Does that mean it is always enabled?

---

Edward R. Joell MCSD MCDBA