Using sqleditor how to#
Using sqleditor code#

The editor window uses the same authentication information as the current connection. Query with Current Connection -Opens a new editor window of the type associated with the current connection in Management Studio. On the File menu, click New, and then select one of the query editor options:

Using sqleditor how to#

This section explains how to open the various editors in SQL Server Management Studio.

For example, if you open a Database Engine Query Editor window using Windows Authentication, you cannot execute Transact-SQL statements that reference objects your Windows login account does not have permissions to access.

Using sqleditor code#

Operations you perform in a code editor are subject to the permissions granted to the authentication account you used to log in. On the File menu, click Save As, Save with Encoding from the down arrow next to the Save button, and then choose Unix or Macintosh under Line Endings. Also, when saving files for UNIX or Macintosh, be sure to save your files with the appropriate document format. If you share files with users at other sites that use distinct code pages, you should save your file with the appropriate Unicode code page to prevent errors when reading the file. Any of the editors can also be used to edit text files.

Management Studio supports four editors: the Database Engine Query Editor for editing Transact-SQL scripts, the DMX and MDX editors for editing scripts using those languages, and the XML/A editor for editing XML/A scripts or XML files. When opened, each editor window appears as a tab in the central pane of Management Studio. This topic describes how to open the Database Engine Query, MDX, DMX, or XML/A editors in SQL Server Management Studio. Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)