Cant create/edit stored procs in VS.Net

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

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]

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)
  • 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.sqlserver.setup)
  • 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.setup)
  • RE: Cant Create SQL Server Stored Proc in VS.NET? Help!
    ... when using the SQL server Enterprise Manager with the ... I am using VS.NET 2003 and SQL Server 2000 Developer. ... > procedures on the SQL server through VS.NET Server Explorer. ... > If you don't have sa privilege, please create a user with stored procedure ...
    (microsoft.public.dotnet.framework.adonet)