Post reply

SSMS 2014 not opening PRC/TAB/UDF files in SQL Query Editor

  • November 16, 2017 at 4:29 pm

    #402677

    I am running SQL Server 2014 SP2 CU3 on Windows 7 Enterprise. I'm unable to get SSMS to open files with extensions such as PRC, TAB, UDF, etc., with the SQL Query Editor. Other people in my shop are having the same problem.

    • The local path for SSMS 2014 is "C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe".
    • Using Windows Explorer, under Properties for a file of each extension, I've set "Opens with" to the above path.
    • Within SSMS, under Tools -> Options -> File Extension, I've set each extension to "SQL Query Editor."
    • There are a handful of solutions I've found on the web (including a SSC Forum entry) for SQL Server 2012, that involve setting the Default name/value in HKCU\Software\Microsoft\SQL Server Management Studio\11.0\FileExtensionMapping\PRC (TAB, etc.) to {B5A506EB-11BE-4782-9A18-21265C2CA0B4}. I checked the corresponding path for 12.0 and this was already set.
    • The above solutions also said to set the Custom name/value in HKCU\Software\Microsoft\SQL Server Management Studio\11.0\Default Editors\PRC (TAB, etc.) to {B5A506EB-11BE-4782-9A18-21265C2CA0B4}. I added that for PRC for 12.0, but didn't go any further when that didn't work.
    • I've rebooted after the above. Several times. (Grrr....)

    Since many of the files under source control come with the various descriptive extensions for object types, I'd like to be able to open them in the query editor and not jump through copy/paste hoops. Anyone have any suggestions?

    Thanks!

  • November 16, 2017 at 4:50 pm

    #1968450

    it's a two step process;
    you have to associate the files at windows, and then tell SSMS that you want to edit those extensions as if they were sql code.
    create an empty file of type *.prc, right click choose open with, and browse to the SSMS location.
    after that,you needassign them manually in tools options as seen here:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 17, 2017 at 8:35 am

    #1968539

    If you'll take a look at my original post, you'll see I've already done that.  🙂  Any other thoughts?

    Thanks again.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply