"Kyle Morris" <kmorris-spamfree@crd.bc.ca> wrote in message
news:%23XkDo$NoEHA.3464@TK2MSFTNGP14.phx.gbl...
> 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]
>
>

"alien2_51" <dan.billow"at" wrote:

> You're probably right about the permissions... I would make sure you're a
> dbo in the database you want to create procs from VS.Net in... Also VS.Net
> may try to use Integrated Security by default check this by clicking the
> connection in server explorer.. if so and you have both a SQL login and a
> domain login make sure they're both dbo's... If that doesn't solve your
> problem I'd try posting in a vb.net group...
>
> Dan
>
> "Kyle Morris" <kmorris-spamfree@crd.bc.ca> wrote in message
> news:%23XkDo$NoEHA.3464@TK2MSFTNGP14.phx.gbl...
> > 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]
> >
> >
>
>