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

Chris Jackson

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

Chris Jackson

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