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

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?!
    ... 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. ... H. Norman Schwarzkopf ...
    (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: Set identity_insert
    ... A role MUST have CREATE TABLE permission in order to create ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... and he does use command SET IDENTITY_INSERT ...
    (microsoft.public.sqlserver.security)
  • Re: Web Authentication
    ... Please use such programs only if you have a permission from the ... make a brute force attack to htaccess? ... but i dont know any other ways of authentication. ... scripts in those directories are wirted in PHP Perl and CGI scripting. ...
    (Security-Basics)
  • RE: permission
    ... Never Never Never Never EVER give access like that to the root of ANY drive. ... opening up your system to all scripts, such as scripts that are targeted ... Once that permission is set, ... to the C drive is OK as long as you don't set IIS to list content and other ...
    (Security-Basics)