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

From: alien2_51 (dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion)
Date: 09/22/04

  • Next message: S Shulman: "ASP Security Issue" 
    Date: Wed, 22 Sep 2004 13:40:35 -0700

    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: S Shulman: "ASP Security Issue"

    Relevant Pages

    • RE: copy permissions from one user to another?
      ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- ADD USER TO SERVER ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- SET COMMAND TO FIND USER PERMISSIONS HAS IN CURRENT DATABASE ...
      (microsoft.public.sqlserver.security)
    • Re: Creating a database
      ... Please do yourself a favor, find a local user group, or buy a beginning book on SQL Server or take a class, you will save yourself a great deal of pain in the long run. ... CREATE DATABASE Products ... I can create a stored procedure from within the Server Explorer and from ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Effective Permissions Error with Domain User
      ... I set the database compatibility to 2005. ... server profile trace and found that it was calling the Execute As User. ... This leads me to believe it is some sort of permissions issue. ... Did you get these database from SQL Server 2000 by using a RESTORE command? ...
      (microsoft.public.sqlserver.security)
    • Re: public role question
      ... Who is the owner of the database? ... "Dan Guzman" wrote: ... Windows group and thereby get sysadmin permissions. ... Then I am able to create a stored procedure. ...
      (microsoft.public.sqlserver.security)
    • Re: How to prevent DELETEs in a table
      ... It is the dbo database USER, not server-level groups, that determins ... It has implicit permissions that can not be denied. ... SQL Server just skips any permission validation for sysadmins. ...
      (microsoft.public.sqlserver.server)