Use object name as filename for "script object as"
When using the menu option "script object as..."
1) when creating the new file have the name of the object be the filename. That way it is much easier to find in the tabs of SSMS instead of just another SQLqueryxx.sql file. This would make it much easier to find it again after switching away from that document.
2) have some option setup to make it always be a create and not an alter. When I use the command its so I can see what the object is, I don't want to accidentally modify it so create means sql server will complain if I accidentally run the command
12
votes
Eli
shared this idea