473,224 Members | 1,644 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,224 software developers and data experts.

edit stored procedures in vs.net

Max
I thought in server explorer, I could add or edit stored procedures, but all
I can do is refresh and run...

-Max
Nov 18 '05 #1
5 1138
You should be able to right click on stored procedures and select add new
stored procedure, and you can definitely edit them. What options do you have
in the database menu when you are working in the server explorer?

--
Chris Jackson
Software Engineer
Microsoft MVP - Windows Client
Windows XP Associate Expert
--
More people read the newsgroups than read my email.
Reply to the newsgroup for a faster response.
(Control-G using Outlook Express)
--

"Max" <ma*****@portvista.com> wrote in message
news:_O*******************@twister.tampabay.rr.com ...
I thought in server explorer, I could add or edit stored procedures, but all I can do is refresh and run...

-Max

Nov 18 '05 #2
Max
The database menu gives me only one or two choices depending on what I
click:
On Database: close connection, change login (grayed out)

Nothing on stored procedures or tables. When I select a specific stored
procedure, all I can do is "Run Stored Procedure"

I also noticed my Spelly spellcheck isn't working either. :(

Versions
7.1.3088
1.1.4322
"Chris Jackson" <chrisjATmvpsDOTorgNOSPAM> wrote in message
news:uY**************@TK2MSFTNGP09.phx.gbl...
You should be able to right click on stored procedures and select add new
stored procedure, and you can definitely edit them. What options do you have in the database menu when you are working in the server explorer?

--
Chris Jackson
Software Engineer
Microsoft MVP - Windows Client
Windows XP Associate Expert
--
More people read the newsgroups than read my email.
Reply to the newsgroup for a faster response.
(Control-G using Outlook Express)
--

"Max" <ma*****@portvista.com> wrote in message
news:_O*******************@twister.tampabay.rr.com ...
I thought in server explorer, I could add or edit stored procedures, but

all
I can do is refresh and run...

-Max


Nov 18 '05 #3
Max
Also, I'm using Visual Basic.NET. It's not the enterprise edition, do I need
that?

-M
Nov 18 '05 #4
That I don't know. I have the tools on VS.NET Enterprise - I am not familiar
with the other packages. Sorry. :-(

--
Chris Jackson
Software Engineer
Microsoft MVP - Windows Client
Windows XP Associate Expert
--
More people read the newsgroups than read my email.
Reply to the newsgroup for a faster response.
(Control-G using Outlook Express)
--

"Max" <ma*****@portvista.com> wrote in message
news:jp*********************@twister.tampabay.rr.c om...
Also, I'm using Visual Basic.NET. It's not the enterprise edition, do I need that?

-M

Nov 18 '05 #5
Max
That was it, they had the professional edition on my computer. The
enterprise architect has the sql debugger. Web designers don't get the good
stuff where I work, even tho I do more programming than designing. :(

-M
"Chris Jackson" <chrisjATmvpsDOTorgNOSPAM> wrote in message
news:u$**************@TK2MSFTNGP11.phx.gbl...
That I don't know. I have the tools on VS.NET Enterprise - I am not familiar with the other packages. Sorry. :-(

Nov 18 '05 #6

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...
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...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...

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.