473,407 Members | 2,359 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,407 software developers and data experts.

Edit Stored Procedures

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.
Nov 22 '05 #1
2 1323
Must be a permissions thing. I just doubleclick a sp and can edit it
directly. What sort of allowed connections are you running?
On Sat, 6 Mar 2004 14:01:24 -0500, "Chris Vaughn"
<va********@columbus.rr.com> wrote:
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.


Nov 22 '05 #2
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" <va********@columbus.rr.com> wrote in message
news:%2****************@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.

Nov 22 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Chris Vaughn | last post by:
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...
2
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
5
by: Tim Marshall | last post by:
I was following the thread "Re: Access Treeview - Is it Safe Yet?" with interest and on reading the post describing Lauren Quantrell's SmartTree, I've run into something I don't understand: Stored...
3
by: Steven Blair | last post by:
Hi, CHeck a couple of articles online for debugging stored procedures through the MS IDE. Each article indicates you should right click the SP name from the Server Browser and selected Edit....
0
by: William F. Robertson, Jr. | last post by:
I know this is a little off topic, but I can't seem to figure this out. In Visual Studio 2002 I was creating and edit stored procedures and tables using the server explorer tab. We recently...
5
by: Max | last post by:
I thought in server explorer, I could add or edit stored procedures, but all I can do is refresh and run... -Max
45
by: John | last post by:
Hi When developing vb.bet winform apps bound to sql server datasource, is it preferable to use SELECTs or stored procedure to read and write data from/to SQL Server? Why? Thanks Regards
28
by: mooreit | last post by:
The purpose for my questions is accessing these technologies from applications. I develop both applications and databases. Working with Microsoft C#.NET and Microsoft SQL Server 2000 Production and...
3
by: topmind | last post by:
I am generally new to dot.net, coming from "scriptish" web languages such as ColdFusion and Php. I have a few questions if you don't mind. First, how does one go about inserting dynamic SQL...
11
by: peter | last post by:
I am trying to get a SQL stored procedure to use user maintained MQT implicitly which raises questions on when they are used or not used. In theory you would expect the stored procedure to pick up...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.