Edit Stored Procedures

C

Chris Vaughn

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.
 
D

Dan Brussee

Must be a permissions thing. I just doubleclick a sp and can edit it
directly. What sort of allowed connections are you running?
 
É

Éric Moreau

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VS.Net - Opening SQLS2k Stored Procedures in the IDE 7
Cannot edit stored procedures 3
SQL Server does not DELETE rows for real 2
Source Safe Stored Procedure Versioning Problem 1
pros and cons of using stored procedures for VB app ? 2
SQL Stored Procedures / Source Safe / Visual Studio 10
Stored Procedures in .NET 3
Access 2000 - Edit SQL Stored Procedures 5

Top