I'm looking for a way to have sql server treat a different file extension as an .sql file... My company policy is that we name stored procedures as .PRC instead of .SQL. This makes it a hassle to open a file and edit/execute it. While I can associate SQL Server Management Studio to open the file, it doesn't treat it as a script so all the options to execute the script as well as color coding of the script are disabled. I'm looking for a way to have sql server treat