SQLCMD mode setting - MS SQL Server Management Studio 2008 R2

Hello,
I'm going crazy with this.  I'm in the Studio and at the menu I found the SQLCMD MODE, which I changed to "text."  Now I can't find it in the menu.  Where is it hidden?

I'm trying to execute this setting; setvar SqlSamplesDatabasePath   "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\"
>>>Where can I do this?
chimaAsked:
Who is Participating?
 
Paul SConnect With a Mentor Desktop Support Manager / Network AdministratorCommented:
the link I provided is for Microsoft Visual Studio NOT SQL Server Management Studio. I use both and the names can get confusing.

your question title is correct, but in the body I just saw the word "studio", sorry.

this link look more relevant for you:

Editing SQLCMD Scripts in the Transact-SQL Editor
http://msdn.microsoft.com/en-us/library/aa833281(v=vs.80).aspx
0
 
Paul SDesktop Support Manager / Network AdministratorCommented:
How to: Enable SQLCMD mode in the Transact-SQL Editor
http://msdn.microsoft.com/en-us/library/aa833182(v=vs.90).aspx
0
 
chimaAuthor Commented:
777 thank you for the response.  I have a couple more questions about this.  I reckon I can search for these answers, yet if I may ask;
>>> Where is the "Data menu?"
•The Data menu to create a query.
Data menu location
>>> I was able to see the SQLCMD with the "New Query"
•The New Query button on the T-SQL editor toolbar to create a new session with the same connection as the current session.
>>> I'm not sure when the SQLCMD is ON or OFF?  If it shows up on the Query menu does that mean it is OFF?

>>> Where is the "Solution Explorer?"
•Solution Explorer to modify database objects and scripts within a database project.
>>> I found this on my search for "Solution Explorer," but it does not specify in what version?;
http://msdn.microsoft.com/en-us/library/ms173570(v=sql.105).aspx
   This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.


• The Schema Compare feature, by using Export to Editor.

• The Data Compare feature, by using Export to Editor.
0
 
Anthony PerkinsCommented:
It looks like MattSQL has you on the right track in your other related question here:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_28154443.html#a39246138
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.