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)
The Database is not accessible after creating Always On Availability Group
Having created a fully functional SQL Server Always On Availability Group, I connect using SSMS. Upon trying to expand the database, I get ...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
BibleGateway.com - Passage Lookup: John 10:7, 9-10 9I am the gate; whoever enters through me will be saved.[a] He will come in and go out, a...
-
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...
No comments:
Post a Comment