Solved

Default file names in SQL Management Studio

Posted on 2010-09-01
12
470 Views
Last Modified: 2012-05-10
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
Comment
Question by:Larissa T
  • 6
  • 5
12 Comments
 
LVL 9

Expert Comment

by:shalabhsharma
ID: 33579155
0
 
LVL 11

Author Comment

by:Larissa T
ID: 33579259
Nice tutorial, but how it relates to my question?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33582898
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
 
LVL 11

Author Comment

by:Larissa T
ID: 33583013
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
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 33583490
No.  SSMS does not provide that functionality.
0
 
LVL 11

Author Closing Comment

by:Larissa T
ID: 33623614
none
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33623936
I am sorry you did not like the answer, but sometimes the correct answer is you cannot do that.
0
 
LVL 11

Author Comment

by:Larissa T
ID: 33624062
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33632819
>> 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
 
LVL 11

Author Comment

by:Larissa T
ID: 33633115
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33642028
I am sorry, but EE is for posting answers to questions and not wishful thinking on Connect.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33642039
>>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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Select Statement 2 21
SQL Server - Slabs 9 37
SQL - SP needs a little help 9 21
SSRS Dynamic Column Names - Last 8 Weeks 3 5
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now