[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 477
  • Last Modified:

Default file names in SQL Management Studio

When I open procedures in SQL management studio  from object explorer, default file name given to it is SQLQueryNNN.sql. i am using SQL 2008 R2. Is there any options to change in management studio or anywhere else to use procedure name as default file name?
0
Lara F
Asked:
Lara F
  • 6
  • 5
1 Solution
 
shalabhsharmaCommented:
0
 
Lara FEAAuthor Commented:
Nice tutorial, but how it relates to my question?
0
 
Anthony PerkinsCommented:
No. because when you are opening a stored procedure in SSMS you can displaying far more than just the contents of the Stored Procedure, this is true of any object in SQL, be it a User Defined Function, a table, a View, whatever.  That is why it opens as a script to ALTER the Stored Procedure when you click on Modify.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Lara FEAAuthor Commented:
I don' t have problem with script content, what I would like that tab that opens  has name of the object, not SQLSquery1.sql, SQLQuery2.sql etc. I know it will change it when I save it into file, but I don't want additional clicks and typing. I thought may be there are some settings to change it.
0
 
Anthony PerkinsCommented:
No.  SSMS does not provide that functionality.
0
 
Lara FEAAuthor Commented:
none
0
 
Anthony PerkinsCommented:
I am sorry you did not like the answer, but sometimes the correct answer is you cannot do that.
0
 
Lara FEAAuthor Commented:
I am ok with NO as answer and it was accepted. System does not allow me to close question without posting some comments, I have none.
0
 
Anthony PerkinsCommented:
>> System does not allow me to close question without posting some comments, I have none. <<
And that is fine, I was referring to the "B" grade.
0
 
Lara FEAAuthor Commented:
B means Good, not bad :-)
Excellent grade would be for answer that would solve my problem or at least link to
http://connect.microsoft.com/SQLServer/feedback/details/568519/sql-server-management-studio-tab-titles-useless-why-not-let-me-name-them

Thank you for your time.
0
 
Anthony PerkinsCommented:
I am sorry, but EE is for posting answers to questions and not wishful thinking on Connect.
0
 
Anthony PerkinsCommented:
>>Excellent grade would be for answer that would solve my problem <<
Then I am afraid you do need to re-read the EE Guidelines. Specifically:
The correct answer to some questions is "You can't do that."
Sometimes, you will get an answer that isn't what you want to read, but it still may be the correct answer, and you should award points to the Expert that gave you that answer.


0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now