hi everyone:

Do anyone ever create stored procudure of sql server in
vb.net IDE?

In the Server Eeporer windows, after i create a data
connection, i can view the tables,views and stored
procedures ,but right-click "stored procedures", I can not
get the "New Stored Procedure" sub menuitem, what is the
reason? and i can't edit the exist stored procedure in
vb.net.

Can anyone give me a help?

Robert

Which edition of VS .NET do you have? I believe that feature is available
from Enterprise Developer.

On visual studio.net professional you can add a stored procedure by right
clicking on the stored procedure section of the database and select add
stored procedure.

Ken
-------------------------------------------------------

Really?  I've got VS.NET Pro and I'm unable to create or edit Stored
Procedures...I read early on that this functionality is not available in the
Pro version.

| On visual studio.net professional you can add a stored procedure by right
| clicking on the stored procedure section of the database and select add
| stored procedure.
|
| Ken
| -------------------------------------------------------

| > hi everyone:
| >
| > Do anyone ever create stored procudure of sql server in
| > vb.net IDE?
| >
| > In the Server Eeporer windows, after i create a data
| > connection, i can view the tables,views and stored
| > procedures ,but right-click "stored procedures", I can not
| > get the "New Stored Procedure" sub menuitem, what is the
| > reason? and i can't edit the exist stored procedure in
| > vb.net.
| >
| > Can anyone give me a help?
| >
| >
| > Robert
|
|

A-HA!  I discovered the difference...

With VS.NET Pro 2002, you cannot edit or create new Stored Procedures in SQL
Server 7.0 databases -- on the other hand, with SQL Server 2000 you can
edit, create, etc. to your heart's content.

--- Jim ---

| Really?  I've got VS.NET Pro and I'm unable to create or edit Stored
| Procedures...I read early on that this functionality is not available in
the
| Pro version.
|
|


| | On visual studio.net professional you can add a stored procedure by
right
| | clicking on the stored procedure section of the database and select add
| | stored procedure.
| |
| | Ken
| | -------------------------------------------------------


| | > hi everyone:
| | >
| | > Do anyone ever create stored procudure of sql server in
| | > vb.net IDE?
| | >
| | > In the Server Eeporer windows, after i create a data
| | > connection, i can view the tables,views and stored
| | > procedures ,but right-click "stored procedures", I can not
| | > get the "New Stored Procedure" sub menuitem, what is the
| | > reason? and i can't edit the exist stored procedure in
| | > vb.net.
| | >
| | > Can anyone give me a help?
| | >
| | >
| | > Robert
| |
| |
|

Hi Jim,

Thanks, after i installed the VS.NET enterprise version, I can create
Stored procedure in .net Server explorer! Great.

Anyway, Even if SQLSERVER2000, I couldn't do that in professional
VS.NET.

Robert

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Well, then what I said was right! :-)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hello all,

Here's my two cents worth.

I am running vs.net pro, with multiple SQL 2000 servers around the
network.

I can add and edit sprocs on the MSDE/SQL (2000) database on my local
laptop, however when I connect to one of the production SQL servers
(not on my laptop), I cannot.

I am guessing that the enterprise version of vs can edit 'enterprise'
SQL objects wheras pro can only do local.

DS