Cant create/edit stored procs in VS.Net

From: Kyle Morris (kmorris-spamfree_at_crd.bc.ca)
Date: 09/22/04

  • Next message: alien2_51: "Re: Cant create/edit stored procs in VS.Net" 
    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: alien2_51: "Re: Cant create/edit stored procs in VS.Net"

    Relevant Pages

    • Re: SQL/ADO (2.8) Timeout Error - Cant resolve
      ... > Server 2000 back end. ... > timeout limit. ... And I’ve used SQL Query Analyzer to run the ... I am running a stored procedure that will backup a SQL Server ...
      (microsoft.public.sqlserver.clients)
    • Re: How to test a custom conflict resolver procedure
      ... once I set my stored procedure as a custom resolver? ... Here is an example of a custom resolver I wrote which might help you ... --creating the stored procedure conflict resolver ... Looking for a SQL Server replication book? ...
      (microsoft.public.sqlserver.replication)
    • Re: quality of service
      ... company that hosts my company's web site and connected SQL Server database. ... The same stored procedure is called from a number of different web pages ... The company that hosts my web site and connected SQL ... this clustering is indicative of slowed or failed SQL Server responses due ...
      (microsoft.public.sqlserver.server)
    • Re: Error: Executing Stored Procedures-- Cannot Pass TimeStamp Values From sqlCommand Object Parame
      ... The @RowV Values when it reaches the stored procedure on SQL server always gets reset to 0x00 No matter what value I set it to. ... I am using timestamps to determine if the row has been updated on the server before I apply the new updates. ... @ProviderID smallint, ... @RowOut timestamp OUTPUT ...
      (microsoft.public.dotnet.framework.adonet)
    • Cant create/edit stored procs in VS.Net
      ... The Visual Studio help says that I can use the Server Explorer to ... explorer database "stored procedure" node and a popup menu will enable the ...
      (microsoft.public.vsnet.ide)