Take back control over SQL script files (SQL Server 7/2000)

You may have noticed that certain applications (rather rudely, one might say) assume ownership of your SQL script file types without so much as a by your leave. Visual Studio .NET is notorious for this. Sure, sometimes this is fine, if you do, in fact, spend most of your time in that environment. But DBAs often feel more comfortable working with scripts in SQL Query Analyzer. Luckily, there's a very quick way to take back control over your script files. Simply choose Tools | Options, and then click on the General tab. You'll notice a check box called Select SQL Query Analyzer As The Default Editor For Query File Extensions. Select this check box, click OK, and you're all set.