Re: SMSS - script to new window uses sp_executesql?!

I found the link and I applied. Hopefully, I will be accepted in time
to submit this, unless someone else wants to...

KJ wrote:
I went to the Connect site, but it says "You need permission to submit
feedback in this area. To apply for permission, browse through your
choices on the Available Connections page." I can't find how to do
that.

Paul A. Mestemaker II [MSFT] wrote:
Arnie,

There is a new set of options for generating scripts in SQL Server 2005 SP2.
Tools | Options | Scripting. I've reproduced this behavior and my first
guess is that it is not something that we will be able to fix before
releasing SP2.

Could somebody please file this on Microsoft Connect and vote on it?
http://connect.microsoft.com/SQLServer/

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/


"Arnie Rowland" <arnie@xxxxxxxx> wrote in message
news:%232nl%23VXFHHA.3616@xxxxxxxxxxxxxxxxxxxxxxx
That's odd, I can only replicate the behavior by using the 'Generate
Scripts' wizard.

Even if the setting it [True] in the Generate Scripts wizard,
right-clicking on the object and scripting to a new windows as CREATE does
NOT replicate.

Hummm...

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to
the top yourself.
- H. Norman Schwarzkopf


"KJ" <n_o_s_p_a__m@xxxxxxxx> wrote in message
news:1164995357.600708.144770@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am not using the Wizard, only right-clicking the proc name under
Programmability->Stored Procedures

Arnie Rowland wrote:
Thanks, I have not used the Wizard to script individual procedures, so I
had
not seen that behavior.

If you just right click on the procedure, and select script to new
window as
CREATE, it does not happen there as you describe -only on the wizard.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to
the
top yourself.
- H. Norman Schwarzkopf


"KJ" <n_o_s_p_a__m@xxxxxxxx> wrote in message
news:1164993819.213218.103340@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Set the IF NOT EXISTS scripting option to true, then right-click any
sp
and choose:

Script Stored Procedure as->Create to->New query editor window.


Arnie Rowland wrote:
What you are describing is not the normal behavior.

Please tell us exactly what you do, step by step, in order to this
kind
of a
script.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer
to
the
top yourself.
- H. Norman Schwarzkopf


"KJ" <n_o_s_p_a__m@xxxxxxxx> wrote in message
news:1164984736.958544.17310@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Is there any way to get the old "script to new window as" instead
of
the new style that uses:

EXEC dbo.sp_executesql @statement = N'ALTER PROCEDURE
[dbo].[usp_GetSeri...

I can't believe this is the only way to script a proc to a query
window...






.

Relevant Pages

  • Re: SMSS - script to new window uses sp_executesql?!
    ... I went to the Connect site, but it says "You need permission to submit ... There is a new set of options for generating scripts in SQL Server 2005 SP2. ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.tools)
  • Re: SMSS - script to new window uses sp_executesql?!
    ... There is a new set of options for generating scripts in SQL Server 2005 SP2. ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.tools)
  • Re: How can I have table and column definitions?
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... H. Norman Schwarzkopf ... I want to develop a code generator for our Data-Access Layer and I'd ...
    (microsoft.public.sqlserver.clients)
  • Re: Improve Query
    ... ....Somehow, I think that you have a different question in mind, but it is ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... H. Norman Schwarzkopf ...
    (microsoft.public.sqlserver.mseq)
  • Re: SQL-Server 2005 on Windows VISTA
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... You can't help someone get up a hill without getting a little closer to the ... H. Norman Schwarzkopf ...
    (microsoft.public.sqlserver.setup)