Search code examples
sql-serversql-server-2008ssms

Default encoding in SQL Server Management Studio

I have recently had SSMS 2008 re-installed on my laptop

When I click "New Query..", I am now prompted to select the encoding for the file, something I was never asked to do before

I have associated sql againt "SQL Query Editor with Encoding" in the Text Editor section of the Option and restarted SSMS

What can I do to associate with an encoding as I don't want to select everytime I do a new query or open an existing sql file

Solution

  • I am such an idiot - I changed the association to "SQL Query Editor" and it now all works fine

    The "with Encoding" bit should really have tipped me off!