SSMS (SQL Server Management Studio) will happily load a *.sql file and execute it as a SQL Script.
However, we store our DDL files as .DDL.
I was able to convince SSMS to treat these as sql scripts in the following way:
Tools -> Options
Expand Text Editor
Select File Extension
Add an extension. NOTE: Make sure to select "SQL Query Editor" in the "Editor" drop-down.
And, voila!
Subscribe to:
Post Comments (Atom)
Get Restart log using PowerShell
I'm often curious about a restart on a Windows server system. An easy way to get a list of the restart and what initiated it is to use t...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
NOTE: These instruction apply to the connections, reports, menus, etc in Oracle SQL Developer. If you are looking to change the font of you...
-
We have very basic AIX, with no bells or whistles installed. To create a launch script, the startmanager, startserver, and starnode scripts...
No comments:
Post a Comment