Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


VSS For Stored Procedures


VSS For Stored Procedures

Author
Message
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9452 Visits: 9517
Sherjon (6/19/2008)
Hey Grasshopper,

We installed the x86 version of SP2 because we have 32 bit machines. We have the 'script' entry for Tools which is nice because we can output the 'IF exists..' line in the CREATE script.

The only output Save options we have are 'SQL Server Files .SQL' and All Files(*.*).

I will re-install SP2(Maybe there is a later version) to see if the Save As option displays. If this works, I'll buy any book that you have published at retail price.

Much Appreciated !BigGrin

The Save options are NOT on the File Type drop down! They are on the SAVE button itself!

Look at the SAVE button on the Save dialog: The should be a tiny down-arrow on the right-hand side. Click that arrow. Then select "Save with encoding.." Bingo!

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Sherjon
Sherjon
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 25
To all those who responded,

Thank you very much. The winner is grasshopper, because, although it is a little cumbersome, the Script Wizard does indeed produce ANSI text output.

The SQL Server 2000 script would generate an 'IF exists' clause that would DROP the SPROC and then CREATE a new one. IF we discover a way to append a drop Script and a Create script, we will have it made.

Thanks again to all who responded
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9452 Visits: 9517
Did you try what I suggested?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9452 Visits: 9517
By the way, his name isn't Grasshopper, that's his posting rank. His name is asdfgh.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9452 Visits: 9517
Sherjon (6/19/2008)
The winner is grasshopper, because, although it is a little cumbersome, the Script Wizard does indeed produce ANSI text output.

The SQL Server 2000 script would generate an 'IF exists' clause that would DROP the SPROC and then CREATE a new one. IF we discover a way to append a drop Script and a Create script, we will have it made.


I can show you how to do that, but you'll have to get your save button to work because it won't work with the Wizard.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Sherjon
Sherjon
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 25
Hi RBarryYoung,

Please do. That Save button would be awesome.

BTW, I did not mean to offend you in any way with the 'winner' comment. It just happened to be the one that worked for us. If you could tell u how to get the Save button with the arrows, that would be wonderful. We would greatly appreciate it.
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9452 Visits: 9517
Sherjon (6/19/2008)
Hi RBarryYoung,

Please do. That Save button would be awesome.

BTW, I did not mean to offend you in any way with the 'winner' comment. It just happened to be the one that worked for us. If you could tell u how to get the Save button with the arrows, that would be wonderful. We would greatly appreciate it.

*sigh* Please talk straight. Did you try what I suggested? Are you saying that you do NOT have the arrow on your save button. If so, then please provide your server AND client info: SSMS version and OS version & SP's.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
TheSQLGuru
TheSQLGuru
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 6002 Visits: 8314
A screenshot or two could be helpful here too. A picture is worth ...

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9452 Visits: 9517
OK, I think that I know what the problem is here: When you script the procedure, do NOT script it directly to a file. That option does not have the Save Option.

Instead, script it to a "New Query window..." and then save it from there. That Save dialog does have the Save Options on the Save button.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)SSCrazy Eights (9.5K reputation)

Group: General Forum Members
Points: 9452 Visits: 9517
Good point Kevin.

I have attached two screen shots that show how to get the Save Options that the OP had in SQL2000.

This is how you select the Script to New Query Windo for the procedure:


And this is the Save Dialog that you should see, with the Save Options:


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Attachments
ScreenShot006.jpg (81 views, 166.00 KB)
ScreenShot007.jpg (80 views, 162.00 KB)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search