Cant create/edit stored procs in VS.Net
From: Kyle Morris (kmorris-spamfree_at_crd.bc.ca)
Date: 09/22/04
- Next message: Randy Hersom: "How to open ports in code"
- Previous message: Christopher Walls: "SQL Mail: Missing From Address"
- Next in thread: alien2_51: "Re: Cant create/edit stored procs in VS.Net"
- Reply: alien2_51: "Re: Cant create/edit stored procs in VS.Net"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Sep 2004 13:08:15 -0700
Hi All.
The Visual Studio help says that I can use the Server Explorer to
create/edit stored procedures. The example says to right click the server
explorer database "stored procedure" node and a popup menu will enable the
creation of a new stored procedure.
When i do this - i only get "refresh" and "properties"
When i browse the database using SQLServer enterprise manager - the option
to create datatable or stored procedure does appear in the popup menu.
How do i make this option(s) appear in VS development environment ?
I'm sure it must be an incorrect permission setting on the SQL Server side
of things. Either permissions withing Sql Server or on the W2k Server it
runs on.
Cheers!
Kyle
[P.S. take out the obvious from my email address to reply to me directly]
- Next message: Randy Hersom: "How to open ports in code"
- Previous message: Christopher Walls: "SQL Mail: Missing From Address"
- Next in thread: alien2_51: "Re: Cant create/edit stored procs in VS.Net"
- Reply: alien2_51: "Re: Cant create/edit stored procs in VS.Net"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|