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)
  • 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)
  • 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)