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)
DBT-50000 when using DBCA.bat on Windows (Oracle 19.11)
I’ve been having some trouble getting DBCA to run in order to create databases. Thought I’d share it with you, and thus document it for la...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
I was not able to find what I considered a good, clear reference for this when I recently encountered it at a customer installation. I fou...
-
I spent a lot of time on this one, and it wasn't clear from examples precisely how the various items should be used together. The form...
No comments:
Post a Comment