Re: Edit Stored Procedures

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Éric Moreau (eric.moreau_.N.O.S.P.A.M.__at_videotron.ca)
Date: 03/07/04 

Date: Sun, 7 Mar 2004 10:37:25 -0500

You need the enterprise edition of VS.Net.

With the Pro edition, you can only edit MSDE stored proc. 

-- 
HTH
Éric Moreau, MCSD
Conseiller Principal / Senior Consultant
Concept S2i inc.(www.s2i.com)
"Chris Vaughn" <vaughn2974@columbus.rr.com> wrote in message
news:%23Xa$M36AEHA.2628@TK2MSFTNGP11.phx.gbl...
> Does anyone know about a certain setting to edit stored procedures through
> VS.NET 2003? The only options in the context menu are refresh, copy and
> properties. It is my understanding that you should be able to open and
edit
> a stored procedure through server explorer. I am currently running Windows
> XP pro, SQL 2000 and vs.net 2003 Professional Edition. Thanks in advance.
>
>

Relevant Pages

  • Do I need Pro or Dev Edition of .NET ?
    ... Will the VS.NET Pro edition allow me to edit .DLL's? ... we were tied to them for enhancements ect, but i'm thinking I can do the easy ... I'm a VB / SQL developer with a bit of ASP, ...
    (microsoft.public.dotnet.general)
  • Re: Simple Best Practice Question
    ... I am unsure how to go about this. ... > In short the answer is Stored Procedures ... edit and delete records or do I use stored procedures?? ... >> Many thanks in advance for any assistance ...
    (microsoft.public.sqlserver.programming)
  • Re: MSSQL vs. SYBASE
    ... > Adding RAISERROR is not an option, we would have to edit 1,000+ stored ... > procs. ... Then you would have to tame ADO. ... 1000 stored procedures in one database. ...
    (microsoft.public.sqlserver.programming)
  • Editting Stored Procedures in Query Analyzer Adding Alter Incorrectly
    ... I have created a series of stored procedures that happen to create ... Now when I try to edit the procedure in Query Anylyzer, ... Notice that the "ALTER" was incorrectly placed where the temp table is ...
    (microsoft.public.sqlserver.tools)
  • Re: Cannot edit stored procedures
    ... If there is an Edit ... It's better to edit the scripts anyway -- that way you have the SPs under ... > CHeck a couple of articles online for debugging stored procedures ... > name from the Server Browser and selected Edit. ...
    (microsoft.public.dotnet.languages.csharp)