Re: Cant create/edit stored procs in VS.Net

From: Kevin Stough (KevinStough_at_discussions.microsoft.com)
Date: 03/09/05

  • Next message: Bernhard Lauber: "Re: Rights for Access2000 Upsizing-Wizard" 
    Date: Tue, 8 Mar 2005 19:09:02 -0800

    Did anyone ever find a resolution to this. I'm having the exact same problem
    and haven't been able to determine the source of the problem. I've
    double-checked the permissions and everything looks good. Only options
    available under a Data Connection or the actual Server folders is Refresh and
    Properties.

    Thanks,
    Kevin

    "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]
    > >
    > >
    >
    >
    >

  • Next message: Bernhard Lauber: "Re: Rights for Access2000 Upsizing-Wizard"

    Relevant Pages

    • VS2005 Server Explorer and Stored Procedures
      ... I was merrily dragging and dropping stored procedure ... thing - and while I can get Server Explorer connecting to the data ...
      (microsoft.public.vsnet.general)
    • Re: Debugging SQL Server 2000 from VS 2005
      ... still have to open server explorer which takes forever with lots of stored ... right-click the stored procedure and choose Step ... stored procedure takes forever. ... Is there another way to set set a break ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Autogenerate Stored Procedure parameters...
      ... Have you worked with the Server Explorer? ... connection to your database, and then drag the stored procedure from the ... explorer (under the Data Connections) to a DataSet designer and it should ... create wrappers for making calls to the stored procedure. ...
      (microsoft.public.dotnet.languages.csharp)
    • Trouble using Server Explorer in VB.Net 2003
      ... I am tring to creat a new SQL database using server explorer. ... I can open a data connection to NetSDK ...
      (microsoft.public.data.ado)
    • Re: Any way to debug using SQL SP
      ... > VS.NET does have a SQL Debugger in it. ... > To debug a stored procedure from Server Explorer ...
      (microsoft.public.sqlserver.server)