May 28, 2012 at 1:46 pm
I'm trying to get SSMS to treat files with .PRC extensions as regular sql files.
I went to Options -> Text Editor -> File Extension.
Added PRC as an extension and under "Editor" picked the "Automatic Editor Selector (XML)".
Then clicked the Add button and Apply button and clicked OK.
Nothing doing, it still shows me the file with no color coding.
Anyone know what I am doing wrong?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 28, 2012 at 2:20 pm
OK, got it to work with help from http://www.progtown.com/topic374931-sql-server-2012-rtm.html.
Opened regedit.exe as Administrator.
Then:
On [HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0\FileExtensionMapping\PRC] I changed the Default key value to {B5A506EB-11BE-4782-9A18-21265C2CA0B4}.
On [HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0\Default Editors\PRC] I changed the Custom key value to {B5A506EB-11BE-4782-9A18-21265C2CA0B4}.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply