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 !:D

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.

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.